Remove secondary checkpoint
Previously server reserved WAL for last two checkpoints,
which used too much disk space for small servers.
Bumps PG_CONTROL_VERSION
Author: Simon Riggs
Reviewed-by: Michael Paquier
Branch
--
master
Details
---
https://git.postgresql.org/pg/commitdiff
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
---
https://git.postgresql.org/pg/commitdiff/98267ee83e068afa8bd85c8cc710ab2144e711fa
Modified Files
--
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 pgsql-
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
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
sk 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 (pgsql-comm
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 pgsql-co
On 1 September 2017 at 15:13, Tom Lane wrote:
> Simon Riggs writes:
>> Provisional list of Major Features
>> Branch
>> --
>> REL_10_STABLE
>
> If you don't commit that to HEAD, it's going to disappear the next
> time Bruce or I update the
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
--
src/test/recovery/t/006
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
--
src/test/recover
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 p
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 chang
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 fil
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 deletio
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 insertio
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 rec
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
---
https://git.postgresql.org/pg/commitdiff/a79122b0619
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
---
https://git.postgresql.org/pg/commitdiff/024711b
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
--
src/ba
temporary measure put in place
by 546c13e11b29a5408b9d6a6e3cca301380b47f7f.
Author: Simon Riggs
Reviewed-by: Tom Lane, Michael Paquier
Discussion:
http://postgr.es/m/canp8+j+vvxmrul_i2buvdhmevv5tqu0hm2+c5n+kdvwhjuo...@mail.gmail.com
Branch
--
master
Details
---
https://git.postgresql.org
Additional tests for subtransactions in recovery
Tests for normal and prepared transactions
Author: Nikhil Sontakke, placed in new test file by me
Branch
--
master
Details
---
https://git.postgresql.org/pg/commitdiff/0352c15e5ab4f70c3ab2ac1d48d9f38a5dd11786
Modified Files
-
On 26 April 2017 at 15:47, Peter Eisentraut
wrote:
> On 4/23/17 17:14, Simon Riggs wrote:
>> Workaround for RecoverPreparedTransactions()
>>
>> Force overwriteOK = true while we investigate deeper fix
>
> This is causing a compiler warning. What is the time line on
&g
Workaround for RecoverPreparedTransactions()
Force overwriteOK = true while we investigate deeper fix
Proposed by Tom Lane as temporary measure, accepted by me
Branch
--
master
Details
---
https://git.postgresql.org/pg/commitdiff/546c13e11b29a5408b9d6a6e3cca301380b47f7f
Modified Files
Fix LagTrackerRead() for timeline increments
Bug was masked by error in running 004_timeline_switch.pl that was
fixed recently in 7d68f2281a.
Detective work by Alvaro Herrera and Tom Lane
Author: Thomas Munro
Branch
--
master
Details
---
https://git.postgresql.org/pg/commitdiff/8463880
Fix minor typo in comment
Reported-by: Amit Langote
Branch
--
master
Details
---
https://git.postgresql.org/pg/commitdiff/123aaffb5b881f3dadaac676877a90b50233a847
Modified Files
--
src/backend/catalog/partition.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
--
Sen
Exit correctly from PrepareRedoRemove() when not found
Complex crash bug all started with this failure.
Diagnosed and fixed by Nikhil Sontakke, reviewed by me.
Reported-by: Jeff Janes
Author: Nikhil Sontakke
Discussion:
https://postgr.es/m/CAMkU=1xBP8cqdS5eK8APHL=x6rhmmm2vg5g+qamduutsycw...@mail
Don’t push nextid too far forwards in recovery
Doing so allows various crash possibilities. Fix by avoiding
having PrescanPreparedTransactions() increment
ShmemVariableCache->nextXid when it has no 2PC files
Bug found by Jeff Janes, diagnosis and patch by Pavan Deolasee,
then patch re-designed fo
Allow COMMENT ON COLUMN with partitioned tables
Amit Langote
Branch
--
master
Details
---
https://git.postgresql.org/pg/commitdiff/51175f3638524231405e674e40bde159b0b76727
Modified Files
--
src/backend/commands/comment.c | 3 ++-
src/test/regress/expected/create_
Mention pg_index changes also cause relcache invalidation
Amit Langote, additional line by me
Branch
--
master
Details
---
http://git.postgresql.org/pg/commitdiff/2c2ecddcffba979ce3457bce3655136b6230a127
Modified Files
--
src/backend/utils/cache/inval.c | 7 ---
1 file ch
Reset API of clause_selectivity()
Discussion:
https://postgr.es/m/cakjs1f9yurjqw9pdnzl+rmotsp2voytkpxkgnmfjeo-qz5o...@mail.gmail.com
Branch
--
master
Details
---
http://git.postgresql.org/pg/commitdiff/ac2b09508834c9d6b7ec9467e876213b0304c792
Modified Files
--
contrib/file_
Always SnapshotResetXmin() during ClearTransaction()
Avoid corner cases during 2PC with 6bad580d9e678a0b604883e14d8401d469b06566
Branch
--
master
Details
---
http://git.postgresql.org/pg/commitdiff/cd0cebaf7d1ab04427d4045edf7121a8f3753d8b
Modified Files
--
src/backend/access
On 6 April 2017 at 09:11, Robert Haas 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/
PostgreSQL Development, 24x7 S
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 |
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
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 7b504e
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 +-
configure.
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 pgsql-comm
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/
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
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
On 1 April 2017 at 08:41, Andres Freund 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, Training & Services
--
Sent
On 30 March 2017 at 19:31, Erik Rijkers 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 ‘pgrowlocks’:
> pgrowlocks.c:105:6
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 pgsql-comm
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
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
--
src/b
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
--
maste
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 and
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 +++---
src/bac
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
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
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
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 p
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
--
contrib/pg
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
s 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
---
f 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
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
--
ables 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 Support, Remote DBA,
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
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(+)
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 change
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
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, revie
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
---
http://git.postgresql.org/pg/commitdiff/9eb344f
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 insert
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 sh
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 pg
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 ++
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 pgsql-commi
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 pgsql-commi
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 pgsql-commi
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 pgsql-commi
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 pgsql-commi
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 Aasma
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 Aasma
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 Aasma
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 Aasma
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 m
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:
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
--
s
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 ++
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
---
http://git.postgresql.org/pg/commitdiff/7c030783a5bd07cadffc2a1018bc33119
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
Ringer, reviewed by Aleksander Alekseev and Simon Riggs
Branch
--
master
Details
---
http://git.postgresql.org/pg/commitdiff/fb093e4cb36fe40a1c3f87618fb8362845dae0f0
Modified Files
--
src/test/perl/PostgresNode.pm | 172 -
src/test/recovery
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 deletion
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 deletion
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 deletion
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(-)
-
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, issue
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
---
http://git.postgresql.org/pg/commitdiff/f2dba881a5e13abc957f0e692749f89c928
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
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
--
REL9_6_ST
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
D
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
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
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
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
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
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
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
1 - 100 of 810 matches
Mail list logo
