[COMMITTERS] pgsql: Fix more crash-safe visibility map bugs, and improve comments.

Fix more crash-safe visibility map bugs, and improve comments. In lazy_scan_heap, we could issue bogus warnings about incorrect information in the visibility map, because we checked the visibility map bit before locking the heap page, creating a race condition. Fix by rechecking the visibility ma

[COMMITTERS] pgsql: Wake WALSender to reduce data loss at failover for async commit.

Wake WALSender to reduce data loss at failover for async commit. WALSender now woken up after each background flush by WALwriter, avoiding multi-second replication delay for an all-async commit workload. Replication delay reduced from 7s with default settings to 200ms and often much less, allowing

[COMMITTERS] pgsql: Wake WALSender to reduce data loss at failover for async commit.

Wake WALSender to reduce data loss at failover for async commit. WALSender now woken up after each background flush by WALwriter, avoiding multi-second replication delay for an all-async commit workload. Replication delay reduced from 7s with default settings to 200ms, allowing significantly reduce

[COMMITTERS] pgsql: Wake WALSender to reduce data loss at failover for async commit.

Wake WALSender to reduce data loss at failover for async commit. WALSender now woken up after each background flush by WALwriter, avoiding multi-second replication delay for an all-async commit workload. Replication delay reduced from 7s with default settings to 200ms, allowing significantly reduce

[COMMITTERS] pgsql: Do unlocked prechecks in bufmgr.c loops that scan the whole buff

Do unlocked prechecks in bufmgr.c loops that scan the whole buffer pool. DropRelFileNodeBuffers, DropDatabaseBuffers, FlushRelationBuffers, and FlushDatabaseBuffers have to scan the whole shared_buffers pool because we have no index structure that would find the target buffers any more efficiently

[COMMITTERS] pgsql: Message style improvements

Message style improvements Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/5d0109bd2776ce918821f360e951270caa96ba8a Modified Files -- src/bin/initdb/initdb.c |4 ++-- src/bin/pg_ctl/pg_ctl.c |2 +- src/bin/pg_dump/compres

[COMMITTERS] pgsql: Documentation spell and markup checking

Documentation spell and markup checking Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/5baf6da71701abcb76487d9de68f7d7dc6c365e9 Modified Files -- doc/src/sgml/catalogs.sgml |4 ++-- doc/src/sgml/docguide.sgml |4 ++-- doc/src/sgml/ecpg.sgml

[COMMITTERS] pgsql: Scan the buffer pool just once, not once per fork, during relati

Scan the buffer pool just once, not once per fork, during relation drop. This provides a speedup of about 4X when NBuffers is large enough. There is also a useful reduction in sinval traffic, since we only do CacheInvalidateSmgr() once not once per fork. Simon Riggs, reviewed and somewhat revised

[COMMITTERS] pgsql: Revert "Wake WALSender to reduce data loss at failover for async

Revert "Wake WALSender to reduce data loss at failover for async commit." This reverts commit 090e8a984cf1a8a3ef7f6db6dc919f843902d80c. Since WalSndWakeup does not exist in 9.0, it's clear that this patch wasn't even compiled in this branch. Perhaps some variant of it is appropriate in 9.0, but f