![]() ![]() Remove support for upgrading unpackaged (pre-9.1) extensions (Tom Lane) Remove support for "opaque" pseudo-types used by pre- PostgreSQL 7.3 servers (Daniel Gustafsson) Remove support for defining foreign key constraints using pre- PostgreSQL 7.3 syntax (Daniel Gustafsson) Remove support for defining operator classes using pre- PostgreSQL 8.0 syntax (Daniel Gustafsson) Wal_keep_size = wal_keep_segments * wal_segment_size (typically 16MB) If you previously used wal_keep_segments, the following formula will give you an approximately equivalent setting: It is specified in megabytes, rather than number of files as with the old parameter. This determines how much WAL to retain for standby servers. ![]() Rename configuration parameter wal_keep_segments to wal_keep_size (Fujii Masao) Previously it returned ALTER TABLE now it returns ALTER MATERIALIZED VIEW. RENAME COLUMN to return a more appropriate command tag (Fujii Masao) Previously it returned ALTER TABLE now it returns ALTER FOREIGN TABLE.įix ALTER MATERIALIZED VIEW. Rename various wait events to improve consistency (Fujii Masao, Tom Lane)įix ALTER FOREIGN TABLE. Queries that join these views to pg_stat_activity and wish to see auxiliary processes will need to use left joins. Prevent display of auxiliary processes in pg_stat_ssl and pg_stat_gssapi system views (Euler Taveira) SELECT round(sum( OLDVALUE / n::float)) AS newvalue FROM generate_series(1, OLDVALUE) s(n) Conversion of old values to new ones can be done using: Previously, this value was adjusted before setting the number of concurrent requests. Make json_to_tsvector() fully check the spelling of its string option (Dominik Czarnota)Ĭhange the way non-default effective_io_concurrency values affect concurrency (Thomas Munro) The previous behavior has been retained in old views by keeping the original function unchanged. This also applies to substring( text FROM pattern ESCAPE text). Previously a null ESCAPE value was taken to mean using the default escape string (a backslash character). This new behavior matches the SQL specification. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |