[COMMITTERS] pgsql: Fix formula in _hash_spareindex.

Fix formula in _hash_spareindex. This was correct in earlier versions of the patch that lead to commit ea69a0dead5128c421140dc53fac165ba4af8520, but somehow got broken in the last version which I actually committed. Mithun Cy, per an off-list report from Ashutosh Sharma Discussion: http://postg

[COMMITTERS] pgsql: Fix remote position tracking in logical replication

Fix remote position tracking in logical replication We need to set the origin remote position to end_lsn, not commit_lsn, as commit_lsn is the start of commit record, and we use the origin remote position as start position when restarting replication stream. If we'd use commit_lsn, we could reque

[COMMITTERS] pgsql: Remove --verbose from PROVE_FLAGS

Remove --verbose from PROVE_FLAGS Per discussion, the TAP tests are really more verbose than necessary, so remove the --verbose flag from PROVE_FLAGS. Also add comments to let folks know how they can enable it if they really wish to, as suggested by Craig Ringer. Author: Michael Paquier, additio

[COMMITTERS] pgsql: psql: Add some missing tab completion

psql: Add some missing tab completion Add tab completion for COMMENT/SECURITY LABEL ON PUBLICATION/SUBSCRIPTION. Reported-by: Stephen Frost Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/553c3bef4cb47bdacb65b87c5460a2775f535a2b Modified Files -- src/b

[COMMITTERS] pgsql: Fix typo

Fix typo Author: Masahiko Sawada Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/d1f103c7396b667e64141412a8a0d12a2eef2930 Modified Files -- src/backend/replication/logical/worker.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via pgsq

[COMMITTERS] pgsql: Fix thinko in BitmapAdjustPrefetchIterator.

Fix thinko in BitmapAdjustPrefetchIterator. Dilip Kumar Discussion: http://postgr.es/m/cafitn-ukavrhwprb0i-u9zfoekgqrrwqjp1wvobskzb-uek...@mail.gmail.com Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/a9a7949134189c29a9b38ac7394c53849684fe4d Modified Files --

[COMMITTERS] pgsql: Adjust min/max values when changing sequence type

Adjust min/max values when changing sequence type When changing the type of a sequence, adjust the min/max values of the sequence if it looks like the previous values were the default values. Previously, it would leave the old values in place, requiring manual adjustments even in the usual/default

[COMMITTERS] pgsql: Speedup 2PC recovery by skipping two phase state files in normal

Speedup 2PC recovery by skipping two phase state files in normal path 2PC state info held in shmem at PREPARE, then cleaned at COMMIT PREPARED/ABORT PREPARED, avoiding writing/fsyncing any state information to disk in the normal path, greatly enhancing replay speed. Prepared transactions that li

[COMMITTERS] pgsql: Clarify documentation of to_tsvector(json(b))

Clarify documentation of to_tsvector(json(b)) Per gripe from Sven R. Kunze Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e75a78656bcaa3faff6b85891ca69d45dd21023f Modified Files -- doc/src/sgml/func.sgml | 5 - 1 file changed, 4 insertions(+), 1 dele

[COMMITTERS] pgsql: Force synchronous commit in new-ish test_decoding test.

Force synchronous commit in new-ish test_decoding test. This was missed in a924c327 ff. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/bae9b8016053c0a434690add7049a9216afef7e2 Modified Files -- contrib/test_decoding/expected/slot.out | 3 +++ contrib/tes

[COMMITTERS] pgsql: Fix two valgrind issues in slab allocator.

Fix two valgrind issues in slab allocator. During allocation VALGRIND_MAKE_MEM_DEFINED was called with a pointer as size. That kind of works, but makes valgrind exceedingly slow for workloads involving the slab allocator. Secondly there was an access to memory marked as unreachable within SlabChe

[COMMITTERS] pgsql: Fix uninitialized variables in twophase.c

Fix uninitialized variables in twophase.c Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/cd740c0dbfb3038eea2e921e82e2f5345d0718c5 Modified Files -- src/backend/access/transam/twophase.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) -- Sent

[COMMITTERS] pgsql: Make min_wal_size/max_wal_size use MB internally

Make min_wal_size/max_wal_size use MB internally Previously they were defined using multiples of XLogSegSize. Remove GUC_UNIT_XSEGS. Introduce GUC_UNIT_MB Extracted from patch series on XLogSegSize infrastructure. Beena Emerson Branch -- master Details --- http://git.postgresql.org/pg/

[COMMITTERS] pgsql: Follow-on cleanup for the transition table patch.

Follow-on cleanup for the transition table patch. Commit 59702716 added transition table support to PL/pgsql so that SQL queries in trigger functions could access those transient tables. In order to provide the same level of support for PL/perl, PL/python and PL/tcl, refactor the relevant code in

[COMMITTERS] pgsql: pageinspect: Add bt_page_items function with bytea argument

pageinspect: Add bt_page_items function with bytea argument Author: Tomas Vondra Reviewed-by: Ashutosh Sharma Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/193f5f9e913f3ead6609cc99be82578e0dedd409 Modified Files -- contrib/pageinspect/btreefuncs.c

[COMMITTERS] pgsql: Capitalize names of PLs consistently

Capitalize names of PLs consistently Author: Daniel Gustafsson Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/afd79873a0b151bfbe5312acebfe361da09c11fd Modified Files -- contrib/postgres_fdw/expected/postgres_fdw.out | 2 +- contrib/postgres_fdw/sql/post