[COMMITTERS] pgsql: Exclude pg_internal.init from BASE_BACKUP

Exclude pg_internal.init from BASE_BACKUP Add docs to explain this for other backup mechanisms Author: David Steele Reviewed-by: Petr Jelinek et al Branch -- master Details ---

[COMMITTERS] pgsql: Grammar typo in security warning about md5

Grammar typo in security warning about md5 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/0703c197adb0bf5fa6c99e8af74b13585bdc9056 Modified Files -- doc/src/sgml/client-auth.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via

[COMMITTERS] pgsql: Exclude special values in recovery_target_time

Exclude special values in recovery_target_time recovery_target_time accepts timestamp input, though does not allow use of special values, e.g. “today”. Report a useful error message for these cases. Reported-by: Piotr Stefaniak Author: Simon Riggs Discussion: https://postgr.es/m/canp8+jjdka

[COMMITTERS] pgsql: Allow SET STATISTICS on expression indexes

Stats Target Authors: Alexander Korotkov, with contribution by Adrien NAYRAT Review: Adrien NAYRAT, Simon Riggs Wordsmith: Simon Riggs Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/5b6d13eec72b960eb0f78542199380e49c8583d4 Modified Files -- doc/src

Re: [COMMITTERS] pgsql: Add psql variables showing server version and psql version.

ery little risk in doing so and significant benefits in being able to rely on scripts that know about versions. Thanks -- Simon Riggshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-committers mailing list (

[COMMITTERS] pgsql: Provisional list of Major Features

Provisional list of Major Features Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/2f5ada2710d6e5a668d6d6b27f93ac545a01bafd Modified Files -- doc/src/sgml/release-10.sgml | 8 +++- 1 file changed, 7 insertions(+), 1 deletion(-) -- Sent via

Re: [COMMITTERS] pgsql: Provisional list of Major Features

On 1 September 2017 at 15:13, Tom Lane <t...@sss.pgh.pa.us> wrote: > Simon Riggs <si...@2ndquadrant.com> writes: >> Provisional list of Major Features >> Branch >> -- >> REL_10_STABLE > > If you don't commit that to HEAD, it's going to disappear

[COMMITTERS] pgsql: Avoid race condition in logical replication test

Avoid race condition in logical replication test Wait for slot to become inactive before continuing. Author: Petr Jelinek Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/4f27c674fd9fb5ba1f2952e2db53886bb5954e8b Modified Files --

[COMMITTERS] pgsql: Avoid race condition in logical replication test

Avoid race condition in logical replication test Wait for slot to become inactive before continuing. Author: Petr Jelinek Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/3950e07eb46ebe99331ca82d659269056470f596 Modified Files --

[COMMITTERS] pgsql: Provisional list of Major Features

Provisional list of Major Features Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/44654f3d2555702279d080e87c70730dc0cb7a9d Modified Files -- doc/src/sgml/release-10.sgml | 8 +++- 1 file changed, 7 insertions(+), 1 deletion(-) -- Sent via

[COMMITTERS] pgsql: Add note about diskspace usage of pg_commit_ts

Add note about diskspace usage of pg_commit_ts Author: Thomas Munro Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/abe85ef1d00187a42e7a757ea0413bc4965a4525 Modified Files -- doc/src/sgml/maintenance.sgml | 30 +- 1 file

[COMMITTERS] pgsql: Add note about diskspace usage of pg_commit_ts

Add note about diskspace usage of pg_commit_ts Author: Thomas Munro Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/28915c7db4da4eaffb8eb0dc5c04c87dcf345eb6 Modified Files -- doc/src/sgml/maintenance.sgml | 30 +- 1

[COMMITTERS] pgsql: Fix typo in comment in SerializeSnapshot

Fix typo in comment in SerializeSnapshot Author: Masahiko Sawada Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/a15b47df357d6c9ac6ebc2ce63bb24c6faddd44c Modified Files -- src/backend/utils/time/snapmgr.c | 2 +- 1 file changed, 1 insertion(+), 1

[COMMITTERS] pgsql: Revert 1f30295eab65eddaa88528876ab66e7095f4bb65

Revert 1f30295eab65eddaa88528876ab66e7095f4bb65 Reported-by: Tom Lane Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/829f12e2690c0442e156069092b05f1edc78b08a Modified Files -- src/backend/utils/time/snapmgr.c | 11 --- 1 file changed, 8

[COMMITTERS] pgsql: Improve replication lag interpolation after idle period

Improve replication lag interpolation after idle period After sitting idle and fully replayed for a while and then encountering a new burst of WAL activity, we interpolate between an ancient sample and the not-yet-reached one for the new traffic. That produced a corner case report of lag after

[COMMITTERS] pgsql: Minor corrections to high availability docs

Minor corrections to high availability docs Startup process is displayed in pg_stat_activity, noted by Yugo Nagata. Transactions can be resolved at end of recovery. Author: Yugo Nagata, with addition by me Branch -- master Details ---

[COMMITTERS] pgsql: Lag tracking for logical replication

Lag tracking for logical replication Lag tracking is called for each commit, but we introduce a pacing delay to ensure we don't swamp the lag tracker. Author: Petr Jelinek, with minor pacing delay code from me Branch -- master Details ---

[COMMITTERS] pgsql: Remove poorly worded and duplicated comment

Remove poorly worded and duplicated comment Move line of code to avoid need for duplicated comment Brought to attention by Masahiko Sawada Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/1f30295eab65eddaa88528876ab66e7095f4bb65 Modified Files --

[COMMITTERS] pgsql: Always SnapshotResetXmin() during ClearTransaction()

Always SnapshotResetXmin() during ClearTransaction() Avoid corner cases during 2PC with 6bad580d9e678a0b604883e14d8401d469b06566 Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/cd0cebaf7d1ab04427d4045edf7121a8f3753d8b Modified Files --

Re: [COMMITTERS] pgsql: Avoid SnapshotResetXmin() during AtEOXact_Snapshot()

On 6 April 2017 at 09:11, Robert Haas <robertmh...@gmail.com> wrote: > Just like the last time you committed this, it seems to have broken > the entire buildfarm. For different reasons, AFAIU. Investigating already. -- Simon Riggshttp://www.2ndQuadrant.com

[COMMITTERS] pgsql: Avoid SnapshotResetXmin() during AtEOXact_Snapshot()

rma and Alexander Korotkov. Simon Riggs Discussion: canp8+jjdxe9b+b9f8cqt-luxxo0pbcb-szffmvadp+akqo4...@mail.gmail.com Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/6bad580d9e678a0b604883e14d8401d469b06566 Modified Files -- src/backend/access/transam/xact.c |

[COMMITTERS] pgsql: Reduce lock level for CREATE STATISTICS

Reduce lock level for CREATE STATISTICS In line with other lock reductions related to planning. Simon Riggs Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/68ea2b7f9b52d35b5fcd9c8d44d88de5a64be3ba Modified Files -- doc/src/sgml/mvcc.sgml | 3

[COMMITTERS] pgsql: Collect and use multi-column dependency stats

Collect and use multi-column dependency stats Follow on patch in the multi-variate statistics patch series. CREATE STATISTICS s1 WITH (dependencies) ON (a, b) FROM t; ANALYZE; will collect dependency stats on (a, b) and then use the measured dependency in subsequent query planning. Commit

[COMMITTERS] pgsql: Allow --with-wal-segsize=n up to n=1024MB

Allow --with-wal-segsize=n up to n=1024MB Other part of Beena Emerson's patch to allow testing Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/00b6b6feb12cef53737287b67ecef6aff1f1d8ab Modified Files -- configure | 6 +-

[COMMITTERS] pgsql: Spelling mistake in comment in utility.c

Spelling mistake in comment in utility.c Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/ed770c325ca374fee7b3b66f5cb29af1a73a1743 Modified Files -- src/backend/tcop/utility.c | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) -- Sent via

[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 ---

[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: 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

Re: [COMMITTERS] Add optional JIT support for expression evaluation.

On 1 April 2017 at 08:41, Andres Freund <and...@anarazel.de> wrote: > Originally slated for v11, discussions at pgconf.us convinced me to > add this to v10. +1 -- Simon Riggshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Trainin

Re: [COMMITTERS] pgsql: Default monitoring roles

On 30 March 2017 at 19:31, Erik Rijkers <e...@xs4all.nl> wrote: > On 2017-03-30 20:20, Simon Riggs wrote: >> >> Default monitoring roles > > > > The buildfarm is showing red (the same errors that I get...): > > > pgrowlocks.c: In function ‘pgrowlock

[COMMITTERS] pgsql: Fix pgrowlocks minor coding oversight

Fix pgrowlocks minor coding oversight Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/ceb3158abe743ddcb213457fc9fcd1a89812194f Modified Files -- contrib/pgrowlocks/pgrowlocks.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via

[COMMITTERS] pgsql: Default monitoring roles

of the above by default, plus others Author: Dave Page Reviewed-by: Stephen Frost, Robert Haas, Peter Eisentraut, Simon Riggs Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/25fff40798fc4ac11a241bfd9ab0c45c085e2212 Modified Files -- contrib/pg_buffercache

[COMMITTERS] pgsql: Correct grammar in error message

Correct grammar in error message "could not generate" rather than "could not generation" from commit 818fd4a67d610991757b610755e3065fb99d80a5 Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/a99f77021f0c8c1c221af4e36b64ca43abd04389 Modified Files --

[COMMITTERS] pgsql: Cleanup slots during drop database

Cleanup slots during drop database Automatically drop all logical replication slots associated with a database when the database is dropped. Previously we threw an ERROR if a slot existed. Now we throw ERROR only if a slot is active in the database being dropped. Craig Ringer Branch --

[COMMITTERS] pgsql: Report catalog_xmin separately in hot_standby_feedback

Report catalog_xmin separately in hot_standby_feedback If the upstream walsender is using a physical replication slot, store the catalog_xmin in the slot's catalog_xmin field. If the upstream doesn't use a slot and has only a PGPROC entry behaviour doesn't change, as we store the combined xmin

[COMMITTERS] pgsql: Reverting 42b4b0b2413b9b472aaf2112a3bbfd80a6ab4dc5

Reverting 42b4b0b2413b9b472aaf2112a3bbfd80a6ab4dc5 Buildfarm issues and other reported issues Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/3428ef79115927c92c6e2ab6f261f5de5dc4e914 Modified Files -- src/backend/access/transam/xact.c | 6 +++---

[COMMITTERS] pgsql: Avoid SnapshotResetXmin() during AtEOXact_Snapshot()

Avoid SnapshotResetXmin() during AtEOXact_Snapshot() For normal commits and aborts we already reset PgXact->xmin Avoiding touching highly contented shmem improves concurrent performance. Simon Riggs Discussion: canp8+jjdxe9b+b9f8cqt-luxxo0pbcb-szffmvadp+akqo4...@mail.gmail.com Bra

[COMMITTERS] pgsql: Minor spelling correction in comment

Minor spelling correction in comment Jon Nelson Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/232c532213446701583e015ca55b5afb9c291445 Modified Files -- src/backend/utils/adt/network.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via

[COMMITTERS] pgsql: Replication lag tracking for walsenders

a difficult topic, with important and subtle behaviour so this shoudl be expected to generate discussion and multiple open items: Test now! Author: Thomas Munro, following designs by Fujii Masao and Simon Riggs Review: Simon Riggs, Ian Barwick and Craig Ringer Branch -- master Details

[COMMITTERS] pgsql: Correct erroneous comment in GetOldestXmin()

Correct erroneous comment in GetOldestXmin() Craig Ringer Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/c137c68ea6bfe860c3e5f4edee7031e136ba4f0c Modified Files -- src/backend/storage/ipc/procarray.c | 1 + 1 file changed, 1 insertion(+) -- Sent via

[COMMITTERS] pgsql: Refactor GetOldestXmin() to use flags

Refactor GetOldestXmin() to use flags Replace ignoreVacuum parameter with more flexible flags. Author: Eiji Seki Review: Haribabu Kommi Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/af4b1a0869bd3bb52e5f662e4491554b7f611489 Modified Files --

[COMMITTERS] pgsql: Assign AccessExclusiveLocks against subxacts in Hot Standby

code changes because original code allowed for this situation but didn’t fully implement it. Discussion: CAKJS1f9vJ841HY=wonnlvbfktwgywdpn72vmxnarcgcjf3s...@mail.gmail.com Author: Simon Riggs and David Rowley Branch -- master Details --- http://git.postgresql.org/pg/commitdiff

[COMMITTERS] pgsql: Improve performance of replay of AccessExclusiveLocks

for transactions which actually took any, avoiding the majority of the performance issue. Refactor MyXactAccessedTempRel into MyXactFlags to allow minimal additional cruft with this. Analysis and initial patch by David Rowley Author: David Rowley and Simon Riggs Branch -- master Details --- http

[COMMITTERS] pgsql: Teach xlogreader to follow timeline switches

of the functionality is with later features. Craig Ringer, reviewed by Simon Riggs and Andres Freund Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/1148e22a82edc96172fc78855da392b6f0015c88 Modified Files -- src/backend/access/transam/xlogutils.c | 215

[COMMITTERS] pgsql: Add a pg_recvlogical wrapper to PostgresNode

Add a pg_recvlogical wrapper to PostgresNode Allows testing of logical decoding using SQL interface and/or pg_recvlogical Most logical decoding tests are in contrib/test_decoding. This module is for work that doesn't fit well there, like where server restarts are required. Craig Ringer Branch

Re: [COMMITTERS] pgsql: Don't scan partitioned tables.

rage for partitioned tables altogether. I thought we already discussed that. Seems strange to mention something not very important that might happen in the future. We could save much more space by optimising FSM. -- Simon Riggshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Su

[COMMITTERS] pgsql: Allow pg_dumpall to dump roles w/o user passwords

and Simon Riggs Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/9a83d56b38c870ce47b7651385ff2add583bf136 Modified Files -- doc/src/sgml/ref/pg_dumpall.sgml | 13 src/bin/pg_dump/pg_dumpall.c | 132 +-- 2 files

[COMMITTERS] pgsql: Ensure ThisTimeLineID is valid before START_REPLICATION

Ensure ThisTimeLineID is valid before START_REPLICATION Craig Ringer Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/5ee2197767f648bc21e324e751b84d42af573b43 Modified Files -- src/backend/replication/walsender.c | 5 + 1 file changed, 5 insertions(+)

[COMMITTERS] pgsql: Enhance docs for ALTER TABLE lock levels of storage parms

Enhance docs for ALTER TABLE lock levels of storage parms As requested by Robert Haas Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/6f3a13ff058f15d565a30c16c0c2cb14cc994e42 Modified Files -- doc/src/sgml/ref/alter_table.sgml | 9 - 1 file

[COMMITTERS] pgsql: Reduce lock levels for table storage params related to planning

Reduce lock levels for table storage params related to planning The following parameters are now updateable with ShareUpdateExclusiveLock effective_io_concurrency parallel_workers seq_page_cost random_page_cost n_distinct n_distinct_inherited Simon Riggs and Fabrízio Mello Branch -- master

[COMMITTERS] pgsql: Allow partitioned tables to be dropped without CASCADE

Allow partitioned tables to be dropped without CASCADE Record partitioned table dependencies as DEPENDENCY_AUTO rather than DEPENDENCY_NORMAL, so that DROP TABLE just works. Remove all the tests for partitioned tables where earlier work had deliberately avoided using CASCADE. Amit Langote,

[COMMITTERS] pgsql: Allow vacuums to report oldestxmin

Allow vacuums to report oldestxmin Allow VACUUM and Autovacuum to report the oldestxmin value they used while cleaning tables, helping to make better sense out of the other statistics we report in various cases. Branch -- master Details ---

[COMMITTERS] pgsql: Small correction to BRIN docs

Small correction to BRIN docs Replace incorrect word "index" with "heap" Takayuki Tsunakawa Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/0bf41dd1908a0c05833168b9972e1c52cb7547b7 Modified Files -- doc/src/sgml/brin.sgml | 2 +- 1 file changed, 1

[COMMITTERS] pgsql: Update ddl.sgml for declarative partitioning syntax

Update ddl.sgml for declarative partitioning syntax Add a section titled "Partitioned Tables" to describe what are partitioned tables, partition, their similarities with inheritance. The existing section on inheritance is retained for clarity. Then add examples to the partitioning chapter that

[COMMITTERS] pgsql: Add keywords for partitioning

Add keywords for partitioning Amit Langote Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/61c9a9dac44c0f0c24342a4fa4f750756ac72f2f Modified Files -- doc/src/sgml/keywords.sgml | 21 + 1 file changed, 21 insertions(+) -- Sent via

[COMMITTERS] pgsql: Improve CREATE TABLE documentation of partitioning

Improve CREATE TABLE documentation of partitioning Amit Langote, with corrections by me Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/c1369fe2ea79724e56ee55e4c87778afd6016942 Modified Files -- doc/src/sgml/ref/create_table.sgml | 107

[COMMITTERS] pgsql: Check interrupts during hot standby waits

Check interrupts during hot standby waits Branch -- REL9_2_STABLE Details --- http://git.postgresql.org/pg/commitdiff/15c54e8363a28ab89e31bafebe6b093a77540b1d Modified Files -- src/backend/storage/ipc/standby.c | 2 ++ 1 file changed, 2 insertions(+) -- Sent via

[COMMITTERS] pgsql: Check interrupts during hot standby waits

Check interrupts during hot standby waits Branch -- REL9_3_STABLE Details --- http://git.postgresql.org/pg/commitdiff/332068a212c0357aa70c187134ba3af32fbd Modified Files -- src/backend/storage/ipc/standby.c | 2 ++ 1 file changed, 2 insertions(+) -- Sent via

[COMMITTERS] pgsql: Check interrupts during hot standby waits

Check interrupts during hot standby waits Branch -- REL9_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/357e061286d2653737eee509f69d70ea85475e3a Modified Files -- src/backend/storage/ipc/standby.c | 2 ++ 1 file changed, 2 insertions(+) -- Sent via

[COMMITTERS] pgsql: Check interrupts during hot standby waits

Check interrupts during hot standby waits Branch -- REL9_5_STABLE Details --- http://git.postgresql.org/pg/commitdiff/ace2cd80a028fc8775146c946d3aff87810e4392 Modified Files -- src/backend/storage/ipc/standby.c | 2 ++ 1 file changed, 2 insertions(+) -- Sent via

[COMMITTERS] pgsql: Check interrupts during hot standby waits

Check interrupts during hot standby waits Branch -- REL9_6_STABLE Details --- http://git.postgresql.org/pg/commitdiff/40b7800da24de920cb9478a22605fa4715dbc30d Modified Files -- src/backend/storage/ipc/standby.c | 2 ++ 1 file changed, 2 insertions(+) -- Sent via

[COMMITTERS] pgsql: Reset hot standby xmin after restart

Reset hot standby xmin after restart Hot_standby_feedback could be reset by reload and worked correctly, but if the server was restarted rather than reloaded the xmin was not reset. Force reset always if hot_standby_feedback is enabled at startup. Ants Aasma, Craig Ringer Reported-by: Ants

[COMMITTERS] pgsql: Reset hot standby xmin after restart

Reset hot standby xmin after restart Hot_standby_feedback could be reset by reload and worked correctly, but if the server was restarted rather than reloaded the xmin was not reset. Force reset always if hot_standby_feedback is enabled at startup. Ants Aasma, Craig Ringer Reported-by: Ants

[COMMITTERS] pgsql: Reset hot standby xmin after restart

Reset hot standby xmin after restart Hot_standby_feedback could be reset by reload and worked correctly, but if the server was restarted rather than reloaded the xmin was not reset. Force reset always if hot_standby_feedback is enabled at startup. Ants Aasma, Craig Ringer Reported-by: Ants

[COMMITTERS] pgsql: Reset hot standby xmin after restart

Reset hot standby xmin after restart Hot_standby_feedback could be reset by reload and worked correctly, but if the server was restarted rather than reloaded the xmin was not reset. Force reset always if hot_standby_feedback is enabled at startup. Ants Aasma, Craig Ringer Reported-by: Ants

[COMMITTERS] pgsql: Check interrupts during hot standby waits

Check interrupts during hot standby waits Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e8ee3d6b859a18d7f7375ceb9e04d256eb18aaec Modified Files -- src/backend/storage/ipc/standby.c | 2 ++ 1 file changed, 2 insertions(+) -- Sent via pgsql-committers

[COMMITTERS] pgsql: Reset hot standby xmin on master after restart

Reset hot standby xmin on master after restart Hot_standby_feedback could be reset by reload and worked correctly, but if the server was restarted rather than reloaded the xmin was not reset. Force reset always if hot_standby_feedback is enabled at startup. Ants Aasma, Craig Ringer Reported-by:

[COMMITTERS] pgsql: Fix format for TAP test docs

Fix format for TAP test docs Small number of fixes to perl docs for TAP tests. Plus two comments that use "xlog" rather than WAL Michael Paquier Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/2e44f379bc0219f6864dbfb901129796e6feec44 Modified Files --

[COMMITTERS] pgsql: Add new TAP tests for pg_recvlogical

Add new TAP tests for pg_recvlogical Craig Ringer, reviewed by Euler Taveira and Naoki Okano Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/3e353a7bc2dd6a9edfffe7e045c810b421f7ecc4 Modified Files -- src/bin/pg_basebackup/Makefile| 2 ++

[COMMITTERS] pgsql: Add pg_recvlogical —-endpos=LSN

Add pg_recvlogical —-endpos=LSN Allow pg_recvlogical to specify an ending LSN, complementing the existing -—startpos=LSN option. Craig Ringer, reviewed by Euler Taveira and Naoki Okano Branch -- master Details ---

[COMMITTERS] pgsql: Add 18 new recovery TAP tests

Add 18 new recovery TAP tests Add new tests for physical repl slots and hot standby feedback. Craig Ringer, reviewed by Aleksander Alekseev and Simon Riggs Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/0813216cb416bf9173ddc7ff3cf495755d943743 Modified Files

[COMMITTERS] pgsql: Fix copy/pasto in file identification

Fix copy/pasto in file identification Daniel Gustafsson Branch -- REL9_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/9410b711deafeec01672f213ec6b8383c137e759 Modified Files -- src/backend/storage/ipc/dsm_impl.c | 2 +- 1 file changed, 1 insertion(+), 1

[COMMITTERS] pgsql: Fix copy/pasto in file identification

Fix copy/pasto in file identification Daniel Gustafsson Branch -- REL9_5_STABLE Details --- http://git.postgresql.org/pg/commitdiff/75684fc1f5bbcb097f8230cb9d897b689d44eb10 Modified Files -- src/backend/storage/ipc/dsm_impl.c | 2 +- 1 file changed, 1 insertion(+), 1

[COMMITTERS] pgsql: Fix copy/pasto in file identification

Fix copy/pasto in file identification Daniel Gustafsson Branch -- REL9_6_STABLE Details --- http://git.postgresql.org/pg/commitdiff/4b47cb35fa516c1bb380ab4edf3131fb6adfacfe Modified Files -- src/backend/storage/ipc/dsm_impl.c | 2 +- 1 file changed, 1 insertion(+), 1

[COMMITTERS] pgsql: Fix copy/pasto in file identification

Fix copy/pasto in file identification Daniel Gustafsson Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/4068eb9918cbbeaba8042fa6fe0c1f5382f2f05f Modified Files -- src/backend/storage/ipc/dsm_impl.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

[COMMITTERS] pgsql: Identify walsenders in pg_stat_activity

Identify walsenders in pg_stat_activity Following 8299471c37fff0b walsender procs are now visible in pg_stat_activity. Set query to ‘walsender’ for walsender procs to allow them to be identified. Discussion:cab7npqs8c76kpsufk_hsdeyrbtg+zz7d0eekjem6txseucb...@mail.gmail.com Michael Paquier,

[COMMITTERS] pgsql: Raise max setting of checkpoint_timeout to 1d

Raise max setting of checkpoint_timeout to 1d Previously checkpoint_timeout was capped at 3600s New max setting is 86400s = 24h = 1d Discussion: 32558.1454471...@sss.pgh.pa.us Branch -- REL9_6_STABLE Details ---

[COMMITTERS] pgsql: Raise max setting of checkpoint_timeout to 1d

Raise max setting of checkpoint_timeout to 1d Previously checkpoint_timeout was capped at 3600s New max setting is 86400s = 24h = 1d Discussion: 32558.1454471...@sss.pgh.pa.us Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/c3c0d7bd701dae4737c974a59ffa9b366110f9c1

[COMMITTERS] pgsql: Fix corruption of 2PC recovery with subxacts

Fix corruption of 2PC recovery with subxacts Reading 2PC state files during recovery was borked, causing corruptions during recovery. Effect limited to servers with 2PC, subtransactions and recovery/replication. Stas Kelvich, reviewed by Michael Paquier and Pavan Deolasee Branch --

[COMMITTERS] pgsql: Fix corruption of 2PC recovery with subxacts

Fix corruption of 2PC recovery with subxacts Reading 2PC state files during recovery was borked, causing corruptions during recovery. Effect limited to servers with 2PC, subtransactions and recovery/replication. Stas Kelvich, reviewed by Michael Paquier and Pavan Deolasee Branch -- master

[COMMITTERS] pgsql: Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL

Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL lazy_truncate_heap() was waiting for VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL, but in microseconds not milliseconds as originally intended. Found by code inspection. Simon Riggs Branch -- REL9_3_STABLE Details --- http://git.postgresql.org/pg

[COMMITTERS] pgsql: Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL

Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL lazy_truncate_heap() was waiting for VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL, but in microseconds not milliseconds as originally intended. Found by code inspection. Simon Riggs Branch -- REL9_1_STABLE Details --- http://git.postgresql.org/pg

[COMMITTERS] pgsql: Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL

Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL lazy_truncate_heap() was waiting for VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL, but in microseconds not milliseconds as originally intended. Found by code inspection. Simon Riggs Branch -- REL9_2_STABLE Details --- http://git.postgresql.org/pg

[COMMITTERS] pgsql: Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL

Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL lazy_truncate_heap() was waiting for VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL, but in microseconds not milliseconds as originally intended. Found by code inspection. Simon Riggs Branch -- REL9_6_STABLE Details --- http://git.postgresql.org/pg

[COMMITTERS] pgsql: Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL

Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL lazy_truncate_heap() was waiting for VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL, but in microseconds not milliseconds as originally intended. Found by code inspection. Simon Riggs Branch -- REL9_5_STABLE Details --- http://git.postgresql.org/pg

[COMMITTERS] pgsql: Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL

Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL lazy_truncate_heap() was waiting for VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL, but in microseconds not milliseconds as originally intended. Found by code inspection. Simon Riggs Branch -- REL9_4_STABLE Details --- http://git.postgresql.org/pg

[COMMITTERS] pgsql: Correct TABLESAMPLE docs

Correct TABLESAMPLE docs Revert to original use of word “sample”, though with clarification, per Tom Lane. Discussion: 29052.1471015...@sss.pgh.pa.us Branch -- REL9_6_STABLE Details --- http://git.postgresql.org/pg/commitdiff/9796882e68367a9259b6d5e84bd0a227b579d586 Modified Files

[COMMITTERS] pgsql: Correct TABLESAMPLE docs

Correct TABLESAMPLE docs Revert to original use of word “sample”, though with clarification, per Tom Lane. Discussion: 29052.1471015...@sss.pgh.pa.us Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/f66472428a51fc484bc5ca81791924d06a6f096d Modified Files

[COMMITTERS] pgsql: Fix minor memory leak in Standby startup

Fix minor memory leak in Standby startup StandbyRecoverPreparedTransactions() leaked the buffer used for two phase state file. This was leaked once at startup and at every shutdown checkpoint seen. Backpatch to 9.6 Stas Kelvich Branch -- REL9_6_STABLE Details ---

[COMMITTERS] pgsql: Fix minor memory leak in Standby startup

Fix minor memory leak in Standby startup StandbyRecoverPreparedTransactions() leaked the buffer used for two phase state file. This was leaked once at startup and at every shutdown checkpoint seen. Backpatch to 9.6 Stas Kelvich Branch -- master Details ---

[COMMITTERS] pgsql: Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL

Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL lazy_truncate_heap() was waiting for VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL, but in microseconds not milliseconds as originally intended. Found by code inspection. Simon Riggs Branch -- master Details --- http://git.postgresql.org/pg/commitdiff

[COMMITTERS] pgsql: Add debug check function LWLockHeldByMeInMode()

Add debug check function LWLockHeldByMeInMode() Tests whether my process holds a lock in given mode. Add initial usage in MarkBufferDirty(). Thomas Munro Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/016abf1fb8333de82a259af0cc7572a4b868023b Modified Files

[COMMITTERS] pgsql: Document LSN acronym in WAL Internals

Document LSN acronym in WAL Internals We previously didn't mention what an LSN actually was. Simon Riggs and Michael Paquier Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/ec03f4121cec6cf885bf40d9dfb53b8368251e99 Modified Files -- doc/src/sgml

[COMMITTERS] pgsql: Dirty replication slots when using sql interface

Dirty replication slots when using sql interface When pg_logical_slot_get_changes(...) sets confirmed_flush_lsn to the point at which replay stopped, it doesn't dirty the replication slot. So if the replay didn't cause restart_lsn or catalog_xmin to change as well, this change will not get

[COMMITTERS] pgsql: New recovery target recovery_target_lsn

New recovery target recovery_target_lsn Michael Paquier Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/35250b6ad7a8ece5cfe54c0316c180df19f36c13 Modified Files -- doc/src/sgml/recovery-config.sgml | 24 +++--

[COMMITTERS] pgsql: Fix wording of logical decoding concepts

Fix wording of logical decoding concepts Be specific about conditions under which we emit >1 copy of message Craig Ringer Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/0c40ab3a88edf654165e562deee0c303a6ebef5e Modified Files --

[COMMITTERS] pgsql: Fix wording of logical decoding concepts

Fix wording of logical decoding concepts Be specific about conditions under which we emit >1 copy of message Craig Ringer Branch -- REL9_6_STABLE Details --- http://git.postgresql.org/pg/commitdiff/33befe035d86d833a5bc7289612722a4e650227d Modified Files --

[COMMITTERS] pgsql: Fix pg_receivexlog --synchronous

Fix pg_receivexlog --synchronous Make pg_receivexlog work correctly with —-synchronous without slots Backpatch to 9.5 Gabriele Bartolini, reviewed by Michael Paquier and Simon Riggs Branch -- REL9_5_STABLE Details --- http://git.postgresql.org/pg/commitdiff

[COMMITTERS] pgsql: Fix pg_receivexlog --synchronous

Fix pg_receivexlog --synchronous Make pg_receivexlog work correctly with --synchronous without slots Backpatch to 9.5 Gabriele Bartolini, reviewed by Michael Paquier and Simon Riggs Branch -- master Details --- http://git.postgresql.org/pg/commitdiff

[COMMITTERS] pgsql: Fix pg_receivexlog --synchronous

Fix pg_receivexlog --synchronous Make pg_receivexlog work correctly with —-synchronous without slots Backpatch to 9.5 Gabriele Bartolini, reviewed by Michael Paquier and Simon Riggs Branch -- REL9_6_STABLE Details --- http://git.postgresql.org/pg/commitdiff

  1   2   3   4   5   6   7   8   >