Re: Speed up Clog Access by increasing CLOG buffers

Dilip Kumar <dilipbalaut@gmail.com>

From: Dilip Kumar <dilipbalaut@gmail.com>

To: Robert Haas <robertmhaas@gmail.com>

Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>, Amit Kapila <amit.kapila16@gmail.com>, Andres Freund <andres@anarazel.de>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2016-09-30T04:26:56Z

Lists: pgsql-hackers

On Thu, Sep 29, 2016 at 8:05 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> OK, another theory: Dilip is, I believe, reinitializing for each run,
> and you are not.

Yes, I am reinitializing for each run.


-- 
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

Commits

Use group updates when setting transaction status in clog.
- baaf272ac908 11.0 landed
- ccce90b39867 10.0 landed
Improve 64bit atomics support.
- e8fdbd58fe56 10.0 landed
Add ProcArrayGroupUpdate wait event.
- d4116a771925 10.0 landed
Make the different Unix-y semaphore implementations ABI-compatible.
- be7b2848c6d8 10.0 cited
Fix broken ALTER INDEX documentation
- 2143f5e12790 9.6.0 cited
Code and docs review for commit 3187d6de0e5a9e805b27c48437897e8c39071d45.
- d12e5bb79bb5 9.6.0 cited
Partition the freelist for shared dynahash tables.
- 44ca4022f3f9 9.6.0 cited
Correct StartupSUBTRANS for page wraparound
- 481725c0ba73 9.6.0 cited
Make idle backends exit if the postmaster dies.
- ac1d7945f866 9.6.0 cited
contrib/sslinfo: add ssl_extension_info SRF
- 49124613f134 9.6.0 cited
Reduce ProcArrayLock contention by removing backends in batches.
- 0e141c0fbb21 9.6.0 cited
Fix `make installcheck` for serializable transactions.
- 253de7e1eb9a 9.6.0 cited
Lockless StrategyGetBuffer clock sweep hot path.
- d72731a70450 9.5.0 cited
Reduce sinval synchronization overhead.
- b4fbe392f8ff 9.2.0 cited