From c0b0501925eacbf2d9c10cd231bf8a14e7c9ef4c Mon Sep 17 00:00:00 2001 From: Andres Freund Date: Tue, 30 Jun 2015 21:00:12 +0200 Subject: [PATCH] Improve 9.5 release notes. 1) Add sgml comments referencing commits. This is useful to search for missing items etc. The comments containing the commit notes are an excerpt from: git log --date=short \ --pretty='format:%cd [%h] %<(8,trunc)%cN: %<(48,trunc)%s%n%n%w(,4,4)%b%n' \ $(git merge-base origin/master upstream/REL9_4_STABLE)..origin/master 2) Improve a handful of existing notes 3) Add missing entries about a couple features. 4) Add a bunch of straight-forward FIXMEs --- doc/src/sgml/release-9.5.sgml | 688 ++++++++++++++++++++++++++++++++-- 1 file changed, 651 insertions(+), 37 deletions(-) diff --git a/doc/src/sgml/release-9.5.sgml b/doc/src/sgml/release-9.5.sgml index a010ffcd0f..0ef79aa9e7 100644 --- a/doc/src/sgml/release-9.5.sgml +++ b/doc/src/sgml/release-9.5.sgml @@ -53,6 +53,9 @@ + Adjust operator precedence to match the SQL standard (Tom Lane) @@ -78,6 +81,9 @@ + Use assignment cast behavior for data type conversions in PL/pgSQL assignments, rather than converting to and @@ -97,6 +103,9 @@ + Allow characters in server command-line options to be escaped with a backslash (Andres Freund) @@ -110,6 +119,9 @@ + Change the default value of include_realm to 1, so that @@ -119,6 +131,9 @@ + Fix REASSIGN OWNED and ALTER OWNER TO @@ -128,6 +143,9 @@ + Remove server configuration parameter autocommit, which was already deprecated and non-operational (Tom Lane) @@ -135,6 +153,9 @@ + Remove pg_authid's rolcatupdate field, as it had no value (Adam Brightwell) @@ -163,18 +184,26 @@ + Add Block Range Indexes (BRIN) (Álvaro Herrera, Heikki Linnakangas, Emre Hasegeli) - BRIN indexes are very compact and store the min/max - values for a range of heap blocks. + BRIN indexes are very compact and cheap to to update by + storing min/max values for a range of heap blocks. + Allow queries to perform accurate distance filtering of bounding-box-indexed objects (polygons, circles) using + Allow GiST indexes to perform index-only scans (Anastasia Lubennikova, Heikki Linnakangas, Andreas Karlsson) @@ -198,6 +233,9 @@ + Add configuration parameter to control the size of GIN pending lists (Fujii Masao) @@ -211,6 +249,9 @@ + Issue a warning during the creation of hash indexes because they are not @@ -228,6 +269,11 @@ + Improve the speed of sorting character and numeric fields (Peter Geoghegan, Andrew Gierth, Robert Haas) @@ -235,6 +281,9 @@ + Extend the infrastructure that allows sorting to be performed by inlined, non-SQL-callable comparison functions to @@ -244,12 +293,23 @@ + Improve in-memory hash performance (Tomas Vondra, Robert Haas) + Improve concurrency of shared buffer replacement (Robert Haas, Amit Kapila) @@ -257,13 +317,52 @@ + - Improve concurrent locking and buffer scan performance (Andres - Freund, Kevin Grittner) + Reduce the number of page locks and pins during index scans (Kevin Grittner) + + + + The primary benefit of this is to allow index vacuums to be blocked + less often. + + + + + + + Make backend local tracking of buffer pins memory efficient (Andres Freund) + + + + Previously each session allocated an array with space for every buffer + in shared_buffers. + + + + + + + Improve lock scalability (Andres Freund) + + + + This particularly addresses scalability problems when running on + systems with multiple CPU sockets. + Allow the optimizer to remove unnecessary references to left outer join subqueries (David Rowley) @@ -271,6 +370,9 @@ + Allow pushdown of query restrictions into window functions, where appropriate @@ -279,13 +381,38 @@ + Speed up CRC (cyclic redundancy check) computations (Abhijit Menon-Sen, Heikki Linnakangas) - + + + + Improve bitmap index scan performance (Teodor Sigaev, Tom Lane) + + + + + + + Speed up CREATE INDEX by avoiding unneccessary memory copies (Robert Haas) + + + + @@ -295,6 +422,9 @@ + Add per-table autovacuum logging control via log_min_autovacuum_duration (Michael Paquier) @@ -306,6 +436,9 @@ + Add new configuration parameter (Thomas Munro) @@ -321,6 +454,9 @@ + Prevent non-superusers from changing on connection startup (Fujii Masao) @@ -337,6 +473,9 @@ + Check Subject Alternative Names in SSL server certificates, if present @@ -350,6 +489,9 @@ + Add system view pg_stat_ssl to report @@ -358,6 +500,9 @@ + Add libpq function PQsslAttribute() @@ -375,6 +520,9 @@ + Make libpq honor any OpenSSL thread callbacks (Jan Urbanski) @@ -395,6 +543,12 @@ + Replace configuration parameter checkpoint_segments with @@ -402,12 +556,17 @@ - This allows the allocation of a large number of WAL - files without keeping them if they are not needed. + This allows the allocation of a large number of WAL files + without keeping them if they are not needed. Thus the default + for has been increased + to 1GB. + Add configuration parameter to control compression of full page images stored in WAL @@ -416,6 +575,9 @@ + Allow recording of transaction commit timestamps when configuration parameter + Allow to be set by ALTER ROLE SET (Peter Eisentraut, Kyotaro Horiguchi) @@ -438,6 +603,9 @@ + Allow running autovacuum workers to respond to configuration parameter changes (Michael Paquier) @@ -445,6 +613,9 @@ + Make configuration parameter read-only (Andres Freund) @@ -459,6 +630,9 @@ + Allow setting on systems where it has no effect (Peter Eisentraut) @@ -466,6 +640,9 @@ + Add environment variables PG_OOM_ADJUST_FILE @@ -481,6 +658,10 @@ + Add system view pg_file_settings @@ -490,6 +671,9 @@ + Add pending_restart to the system view pg_settings to @@ -498,6 +682,9 @@ + Allow ALTER SYSTEM values to be reset with ALTER SYSTEM RESET (Vik @@ -521,6 +708,11 @@ + Add recovery.conf parameter + Add new value always to allow standbys to always archive received @@ -542,6 +737,9 @@ + Add configuration parameter to @@ -555,6 +753,9 @@ + Archive WAL files with suffix .partial during standby promotion (Heikki Linnakangas) @@ -562,6 +763,9 @@ + Add configuration parameter @@ -577,6 +781,11 @@ + Allow labeling of the origin of logical replication changes (Andres Freund) @@ -588,6 +797,10 @@ + Report the processes holding replication slots in pg_replication_slots @@ -600,6 +813,9 @@ + Allow recovery.conf's primary_conninfo to @@ -618,6 +834,10 @@ + Allow INSERTS that would generate constraint conflicts to be turned into @@ -633,6 +853,9 @@ + Add GROUP BY analysis functions GROUPING SETS, @@ -643,10 +866,13 @@ + - Allow multi-column UPDATEs with a single subselect - (Tom Lane) + Allow to set multiple columns in + an UPDATE to the result of a + single subselect (Tom Lane) @@ -656,6 +882,9 @@ + Add new SELECT option SKIP LOCKED to skip locked rows (Thomas Munro) @@ -668,6 +897,9 @@ + Add SELECT option TABLESAMPLE to return a subset of a table (Petr @@ -676,6 +908,9 @@ + Suggest possible matches for mistyped column names (Peter Geoghegan, Robert Haas) @@ -692,6 +927,9 @@ + Add more details about sort ordering in EXPLAIN output (Marius Timmer, @@ -705,6 +943,9 @@ + Have VACUUM log the number of pages skipped due to pins (Jim Nasby) @@ -712,6 +953,9 @@ + Have TRUNCATE properly update the pg_stat* tuple counters (Alexander Shulgin) @@ -726,6 +970,9 @@ + Allow REINDEX to reindex an entire schema using the SCHEMA option (Sawada Masahiko) @@ -733,6 +980,9 @@ + Add VERBOSE option to REINDEX (Sawada Masahiko) @@ -740,6 +990,9 @@ + Prevent REINDEX DATABASE and SCHEMA from outputting object names, unless VERBOSE is used @@ -748,6 +1001,9 @@ + Remove obsolete FORCE option from REINDEX (Fujii Masao) @@ -765,6 +1021,9 @@ + Add row-level security control (Craig Ringer, KaiGai Kohei, Adam Brightwell, Dean Rasheed, Stephen Frost) @@ -781,14 +1040,23 @@ + - Allow control of table WAL logging after table creation - with ALTER TABLE .. SET - LOGGED / UNLOGGED (Fabrízio de Royes Mello) + Allow to convert a WAL logged table to an UNLOGGED + one, and the other way round with + ALTER TABLE .. SET LOGGED / + UNLOGGED (Fabrízio de Royes Mello) + Add IF NOT EXISTS clause to CREATE TABLE AS, @@ -800,6 +1068,9 @@ + Add support for IF EXISTS to ALTER TABLE ... RENAME @@ -808,6 +1079,9 @@ + Allow CURRENT/SESSION_USER to specify the current user in some commands (Kyotaro Horiguchi, Álvaro @@ -825,6 +1099,9 @@ + Allow comments on domain constraints (Álvaro Herrera) @@ -832,6 +1109,9 @@ + Reduce lock levels of some create and alter trigger and foreign key commands (Simon Riggs, Andreas Karlsson) @@ -839,6 +1119,9 @@ + Allow LOCK TABLE .. ROW EXCLUSIVE MODE for those with INSERT privileges (Stephen @@ -852,6 +1135,9 @@ + Apply table and domain CHECK constraints in name order (Tom Lane) @@ -863,6 +1149,10 @@ + Allow CREATE/ + Add support for IMPORT FOREIGN @@ -900,6 +1193,9 @@ + Allow foreign tables to participate in inheritance (Shigeru Hanada, Etsuro Fujita) @@ -912,6 +1208,9 @@ + Allow CHECK constraints to be placed on foreign tables (Shigeru Hanada, Etsuro Fujita) @@ -927,6 +1226,10 @@ + Allow foreign data wrappers and custom scans to implement join pushdown (KaiGai Kohei) @@ -943,6 +1246,10 @@ + Add a set-returning function pg_event_trigger_ddl_commands(), which returns DDL activity @@ -951,6 +1258,9 @@ + Allow event triggers on table rewrites caused by ALTER TABLE (Dimitri @@ -959,6 +1269,9 @@ + Add event trigger support for database-level COMMENT, + Add columns to the output of pg_event_trigger_dropped_objects @@ -992,6 +1309,9 @@ + Allow the XML data type to accept empty or all-whitespace values (Peter Eisentraut) @@ -1004,6 +1324,9 @@ + Fix XML xpath() handling @@ -1018,6 +1341,9 @@ + Allow MACADDR input using the format xxxx-xxxx-xxxx (Herwin Weststrate) @@ -1025,6 +1351,10 @@ + Tighten syntax of INTERVAL precision @@ -1038,6 +1368,9 @@ + Add selectivity estimators for INET/ + Add JSONB functions jsonb_set() @@ -1064,6 +1401,9 @@ + Add several generator functions for JSONB that already existed for JSON (Andrew Dunstan) @@ -1086,6 +1426,9 @@ + Reduce casting requirements to/from JSON and + Allow TEXT, TEXT array, and INTEGER values to be subtracted @@ -1102,6 +1448,9 @@ + Add JSONB operator || @@ -1110,6 +1459,9 @@ + Add json_strip_nulls() @@ -1132,6 +1484,9 @@ + Add generate_series() for NUMERIC values (Plato Malugin) @@ -1139,6 +1494,9 @@ + Allow array_agg() and @@ -1147,6 +1505,10 @@ + Add functions array_position() @@ -1157,6 +1519,9 @@ + Add point-to-polygon @@ -1165,6 +1530,9 @@ + Allow multi-byte characters as escape in SIMILAR TO @@ -1178,6 +1546,9 @@ + Add a width_bucket() @@ -1187,6 +1558,9 @@ + Allow => to specify named parameters in function calls (Pavel Stehule) @@ -1201,6 +1575,9 @@ + Add POSIX-compliant rounding for platforms that use Postgres-supplied rounding functions (Pedro Gimeno Fortea) @@ -1215,6 +1592,9 @@ + Add function pg_get_object_address() @@ -1224,6 +1604,9 @@ + Add function pg_identify_object_as_address() @@ -1233,6 +1616,9 @@ + Loosen security checks for viewing queries in pg_stat_activity, @@ -1250,6 +1636,9 @@ + Add pg_stat_get_snapshot_timestamp() @@ -1263,6 +1652,9 @@ + Add mxid_age() @@ -1271,21 +1663,16 @@ + - Add data type regrole that returns + Add data types regrole regnamespace that returns the OID of a role (Kyotaro Horiguchi) - - - - Add data type regnamespace that returns - the OID of a schema (Kyotaro Horiguchi) - - - @@ -1296,6 +1683,9 @@ + Add MIN()/MAX() aggregates for INET/ + Use 128-bit integers, where supported, as aggregate accumulators (Andreas Karlsson) @@ -1323,6 +1717,9 @@ + Improve support for composite types in PL/Python (Ed Behn, Ronan @@ -1336,6 +1733,9 @@ + Reduce lossiness of PL/Python floating value @@ -1344,6 +1744,9 @@ + Allow specification of conversion routines between SQL data types and data types of procedural languages (Peter Eisentraut) @@ -1369,6 +1772,12 @@ + Improve PL/pgSQL array performance (Tom Lane) @@ -1376,6 +1785,9 @@ + Add ASSERT statement in PL/pgSQL (Pavel Stehule) @@ -1383,6 +1795,9 @@ + Allow more PL/pgSQL keywords to be used as identifiers (Tom Lane) @@ -1401,6 +1816,12 @@ + Move pg_archivecleanup, @@ -1412,6 +1833,9 @@ + Add pg_rewind, which allows re-synchronizing a master server after failback @@ -1420,6 +1844,9 @@ + Allow pg_receivexlog @@ -1433,6 +1860,9 @@ + Allow the pg_receivexlog @@ -1446,6 +1876,9 @@ + Allow vacuumdb to vacuum in parallel using + Add + Make pg_basebackup use a tablespace mapping file when using tar format, @@ -1470,6 +1909,10 @@ + Add pg_xlogdump option