[COMMITTERS] pgsql: Push limit through subqueries to underlying sort, where possible
Push limit through subqueries to underlying sort, where possible. Douglas Doole, reviewed by Ashutosh Bapat and by me. Minor formatting change by me. Discussion: http://postgr.es/m/cade5jyluugneeusyw6q_4mzfytxhxavcqmgasf0yiy8zdgg...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/1f6d515a67ec98194c23a5db25660856c9aab944 Modified Files -- src/backend/executor/nodeLimit.c| 26 + src/test/regress/expected/subselect.out | 52 + src/test/regress/sql/subselect.sql | 46 + 3 files changed, 124 insertions(+) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: pg_prewarm: Add automatic prewarm feature.
pg_prewarm: Add automatic prewarm feature. Periodically while the server is running, and at shutdown, write out a list of blocks in shared buffers. When the server reaches consistency -- unfortunatey, we can't do it before that point without breaking things -- reload those blocks into any still-unused shared buffers. Mithun Cy and Robert Haas, reviewed and tested by Beena Emerson, Amit Kapila, Jim Nasby, and Rafia Sabih. Discussion: http://postgr.es/m/cad__ougubos1vy7kgf6xtjmeqtr4crgav8w+zbay_+mzeit...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/79ccd7cbd5ca44bee0191d12e9e65abf702899e7 Modified Files -- contrib/file_fdw/data/list1.csv | 2 + contrib/file_fdw/data/list2.bad | 2 + contrib/file_fdw/data/list2.csv | 2 + contrib/pg_prewarm/Makefile | 4 +- contrib/pg_prewarm/autoprewarm.c| 924 contrib/pg_prewarm/pg_prewarm--1.1--1.2.sql | 14 + contrib/pg_prewarm/pg_prewarm.control | 2 +- doc/src/sgml/pgprewarm.sgml | 69 ++- src/backend/storage/buffer/freelist.c | 17 + src/include/storage/buf_internals.h | 1 + src/tools/pgindent/typedefs.list| 2 + 11 files changed, 1035 insertions(+), 4 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Don't install ICU collation keyword variants
Don't install ICU collation keyword variants Users can still create them themselves. Instead, document Unicode TR 35 collation options for ICU, so users can create all this themselves. Reviewed-by: Peter Geoghegan Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/958ffb8c286d93d1bfced17e6300d13f9634b431 Modified Files -- doc/src/sgml/charset.sgml| 98 ++-- src/backend/commands/collationcmds.c | 71 -- 2 files changed, 84 insertions(+), 85 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Expand set of predefined ICU locales
Expand set of predefined ICU locales Install language+region combinations even if they are not distinct from the language's base locale. This gives better long-term stability of the set of predefined locales and makes the predefined locales less implementation-dependent and more practical for users. Reviewed-by: Peter Geoghegan Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a79fb8e0c452a9b88206e2abd4add2b432a2596b Modified Files -- doc/src/sgml/charset.sgml| 13 ++--- src/backend/commands/collationcmds.c | 15 --- 2 files changed, 18 insertions(+), 10 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Expand set of predefined ICU locales
Expand set of predefined ICU locales Install language+region combinations even if they are not distinct from the language's base locale. This gives better long-term stability of the set of predefined locales and makes the predefined locales less implementation-dependent and more practical for users. Reviewed-by: Peter Geoghegan Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/51e225da306e14616b690308a59fd89e22335035 Modified Files -- doc/src/sgml/charset.sgml| 13 ++--- src/backend/commands/collationcmds.c | 15 --- 2 files changed, 18 insertions(+), 10 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Don't install ICU collation keyword variants
Don't install ICU collation keyword variants Users can still create them themselves. Instead, document Unicode TR 35 collation options for ICU, so users can create all this themselves. Reviewed-by: Peter Geoghegan Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/2bfd1b1ee562c4e4fd065c7f7d1beaa9b9852070 Modified Files -- doc/src/sgml/charset.sgml| 98 ++-- src/backend/commands/collationcmds.c | 71 -- 2 files changed, 84 insertions(+), 85 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
