Horton

Re: Clock sweep not caching enough B-Tree leaf pages?

Kevin Grittner <kgrittn@ymail.com>

View thread View on postgr.es
From: Kevin Grittner <kgrittn@ymail.com>
To: Kevin Grittner <kgrittn@ymail.com>, Jim Nasby <jim@nasby.net>, Robert Haas <robertmhaas@gmail.com>
Cc: Atri Sharma <atri.jiit@gmail.com>, Bruce Momjian <bruce@momjian.us>, Peter Geoghegan <pg@heroku.com>, Greg Stark <stark@mit.edu>, Ants Aasma <ants@cybertec.at>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2014-05-01T16:00:10Z
Lists: pgsql-hackers 
Kevin Grittner <kgrittn@ymail.com> wrote:

> each connection caused to be held in cache the last page at each
> level of the index.

Apologies for ambiguous terminology there.

To be clear: the most recently accessed page at each level of the index.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Commits

  1. Replace the BufMgrLock with separate locks on the lookup hashtable and