Re: [COMMITTERS] pgsql: pg_receivewal: Improve verbose mode

2017-08-16 Thread Michael Paquier
On Wed, Aug 16, 2017 at 9:27 AM, Peter Eisentraut wrote: > pg_receivewal: Improve verbose mode > > Some informational messages showed up even if verbose mode was not > used. Move them to verbose mode. Perhaps this should be back-patched? It seems to me that this is an oversight from the beginnin

[COMMITTERS] pgsql: Remove dedicated B-tree root-split record types.

2017-08-16 Thread Heikki Linnakangas
Remove dedicated B-tree root-split record types. Since commit 40dae7ec53, which changed the way b-tree page splitting works, there has been no difference in the handling of root, and non-root split WAL records. We don't need to distinguish them anymore If you're worried about the loss of debuggin

[COMMITTERS] pgsql: Changed ecpg parser to allow RETURNING clauses without attached

2017-08-16 Thread Michael Meskes
Changed ecpg parser to allow RETURNING clauses without attached C variables. Branch -- REL9_3_STABLE Details --- https://git.postgresql.org/pg/commitdiff/f8bc6b2f689dc721c753949854bfe605f33149ca Modified Files -- src/interfaces/ecpg/preproc/ecpg.trailer | 7 +-- src/interf

[COMMITTERS] pgsql: Changed ecpg parser to allow RETURNING clauses without attached

2017-08-16 Thread Michael Meskes
Changed ecpg parser to allow RETURNING clauses without attached C variables. Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/3d7a1e2b96b60353c63742d4a8270c67a17744f4 Modified Files -- src/interfaces/ecpg/preproc/ecpg.trailer | 7 +-- src/interf

[COMMITTERS] pgsql: Allow continuation lines in ecpg cppline parsing.

2017-08-16 Thread Michael Meskes
Allow continuation lines in ecpg cppline parsing. Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a6b174f55716c9da2e16804f2d4be4d8f76255ef Modified Files -- src/interfaces/ecpg/preproc/pgc.l | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -

[COMMITTERS] pgsql: Changed ecpg parser to allow RETURNING clauses without attached

2017-08-16 Thread Michael Meskes
Changed ecpg parser to allow RETURNING clauses without attached C variables. Branch -- REL9_4_STABLE Details --- https://git.postgresql.org/pg/commitdiff/bd502753af5d4cc7be58a8e3fea6bc55d1e7b3a5 Modified Files -- src/interfaces/ecpg/preproc/ecpg.trailer | 7 +-- src/interf

[COMMITTERS] pgsql: Changed ecpg parser to allow RETURNING clauses without attached

2017-08-16 Thread Michael Meskes
Changed ecpg parser to allow RETURNING clauses without attached C variables. Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/f2ed2d0a12bede8e6d91b3acc8f6100be3927990 Modified Files -- src/interfaces/ecpg/preproc/ecpg.trailer | 7 +-- src/interf

[COMMITTERS] pgsql: Changed ecpg parser to allow RETURNING clauses without attached

2017-08-16 Thread Michael Meskes
Changed ecpg parser to allow RETURNING clauses without attached C variables. Branch -- REL9_2_STABLE Details --- https://git.postgresql.org/pg/commitdiff/60b135c8262bd7d1d115de1797165a437a890a7a Modified Files -- src/interfaces/ecpg/preproc/ecpg.trailer | 7 +-- src/interf

[COMMITTERS] pgsql: Allow continuation lines in ecpg cppline parsing.

2017-08-16 Thread Michael Meskes
Allow continuation lines in ecpg cppline parsing. Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/954490fecb4ee65e1f3fd5c38f65aaab64ea2099 Modified Files -- src/interfaces/ecpg/preproc/pgc.l | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -

[COMMITTERS] pgsql: Use atomic ops to hand out pages to scan in parallel scan.

2017-08-16 Thread Heikki Linnakangas
Use atomic ops to hand out pages to scan in parallel scan. With a lot of CPUs, the spinlock that protects the current scan location in a parallel scan can become a bottleneck. Use an atomic fetch-and-add instruction instead. David Rowley Discussion: https://www.postgresql.org/message-id/cakjs1f

Re: [COMMITTERS] pgsql: Remove dedicated B-tree root-split record types.

2017-08-16 Thread Tom Lane
Heikki Linnakangas writes: > Remove dedicated B-tree root-split record types. This should have involved a WAL version (XLOG_PAGE_MAGIC) bump, no? The new code can no longer read old WAL, so it's incompatible. regards, tom lane -- Sent via pgsql-committers mailing list

[COMMITTERS] pgsql: Correct representation of foreign tables in information schema

2017-08-16 Thread Peter Eisentraut
Correct representation of foreign tables in information schema tables.table_type is supposed to be 'FOREIGN' rather than 'FOREIGN TABLE' according to the SQL standard. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/9b5140fb503eb50634cd7e080d41f4d9af41e0a6 Modified

[COMMITTERS] pgsql: doc: Add logical replication to comparison matrix

2017-08-16 Thread Peter Eisentraut
doc: Add logical replication to comparison matrix Author: Steve Singer Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/346d5bf1ca33bcf27eda5d23fba3999e6356b905 Modified Files -- doc/src/sgml/high-availability.sgml | 43 +++--

[COMMITTERS] pgsql: doc: Add logical replication to comparison matrix

2017-08-16 Thread Peter Eisentraut
doc: Add logical replication to comparison matrix Author: Steve Singer Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/2327690df4f839ed34b088727a632867cbc0988e Modified Files -- doc/src/sgml/high-availability.sgml | 43 ++

[COMMITTERS] pgsql: doc: Update URL of DocBook XSL stylesheets

2017-08-16 Thread Peter Eisentraut
doc: Update URL of DocBook XSL stylesheets Author: Masahiko Sawada Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/4395f7daf3b40ecbd316bd2a68c253a56013a538 Modified Files -- doc/src/sgml/docguide.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-

[COMMITTERS] pgsql: doc: Update URL of DocBook XSL stylesheets

2017-08-16 Thread Peter Eisentraut
doc: Update URL of DocBook XSL stylesheets Author: Masahiko Sawada Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/0c16efcb533c95cec3e11daa13dba18110231831 Modified Files -- doc/src/sgml/docguide.sgml | 2 +- 1 file changed, 1 insertion(+), 1 del

[COMMITTERS] pgsql: Fix shm_toc.c to always return buffer-aligned memory.

2017-08-16 Thread Heikki Linnakangas
Fix shm_toc.c to always return buffer-aligned memory. Previously, if you passed a non-aligned size to shm_toc_create(), the memory returned by shm_toc_allocate() would be similarly non-aligned. This was exposed by commit 3cda10f41b, which allocated structs containing a pg_atomic_uint64 field with

[COMMITTERS] pgsql: Make the planner assume that the entries in a VALUES list are di

2017-08-16 Thread Tom Lane
Make the planner assume that the entries in a VALUES list are distinct. Previously, if we had to estimate the number of distinct values in a VALUES column, we fell back on the default behavior used whenever we lack statistics, which effectively is that there are Min(# of entries, 200) distinct val

[COMMITTERS] pgsql: Extend the default rules file for contrib/unaccent with Vietname

2017-08-16 Thread Tom Lane
Extend the default rules file for contrib/unaccent with Vietnamese letters. Improve generate_unaccent_rules.py to handle composed characters whose base is another composed character rather than a plain letter. The net effect of this is to add a bunch of multi-accented Vietnamese characters to una

[COMMITTERS] pgsql: Fix pg_atomic_u64 initialization.

2017-08-16 Thread Heikki Linnakangas
Fix pg_atomic_u64 initialization. As Andres pointed out, pg_atomic_init_u64 must be used to initialize an atomic variable, before it can be accessed with the actual atomic ops. Trying to use pg_atomic_write_u64 on an uninitialized variable leads to a failure with the fallback implementation that u

[COMMITTERS] pgsql: pg_dump: Support using synchronized snapshots on standbys

2017-08-16 Thread Peter Eisentraut
pg_dump: Support using synchronized snapshots on standbys This became possible by commit 6c2003f8a1bbc7c192a2e83ec51581c018aa162f. This just makes pg_dump aware of it and updates the documentation. Author: Petr Jelinek Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/

[COMMITTERS] pgsql: pg_dump: Support using synchronized snapshots on standbys

2017-08-16 Thread Peter Eisentraut
pg_dump: Support using synchronized snapshots on standbys This became possible by commit 6c2003f8a1bbc7c192a2e83ec51581c018aa162f. This just makes pg_dump aware of it and updates the documentation. Author: Petr Jelinek Branch -- master Details --- https://git.postgresql.org/pg/commitd