clog boost - Search results in mailing lists

2021-04-01 03:40:16 | Re: MultiXact\SLRU buffers configuration (Thomas Munro)

CLOG_XACTS_PER_PAGE etc. It's not possible to do the same sort of thing for the other SLRUs without overflow problems, and it doesn't seem worth trying to fix that right

2019-07-06 16:05:14 | Re: [Proposal] Table-level Transparent Data Encryption (TDE) and KeyManagement Service (KMS) (Bruce Momjian)

clog truncation that is eventually the product of the freeze. What about referential integrity constraints that need to check primary keys in the encrypted tables? I also don't see a way of delaying that

2016-03-31 09:37:29 | Re: Speed up Clog Access by increasing CLOG buffers (Amit Kapila)

clog buffers patch, Tps is 69340 at 128 client count (very good performance boost) which

2011-12-02 18:20:19 | clog buffers (and FlexLocks) (Robert Haas)

CLOG_BUFFERS from 8 to 32 delivers a significant performance boost on this server at higher

2008-09-19 07:06:00 | Re: Synchronous Log Shipping Replication (Simon Riggs)

clog entries around ClogControlLock. So we should get a scalability boost from all of this

2007-10-25 17:25:27 | 8.3beta1 testing on Solaris (Jignesh K. Shah)

CLOG files, etc and hence sparring reads from going to the disks again. In the end what we achieve is a right sized bufferpool where there are no reads required during a high OLTP environment

2007-08-02 13:50:23 | Re: clog_buffers to 64 in 8.3? (Tom Lane)

boosting NUM_CLOG_BUFFERS has zero cost. The linear searches used in slru.c start to look