Re: 2nd Level Buffer Cache

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>

To: Jim Nasby <jim@nasby.net>

Cc: Gurjeet Singh <singh.gurjeet@gmail.com>, Jeff Janes <jeff.janes@gmail.com>, Kevin Grittner <Kevin.Grittner@wicourts.gov>, rsmogura <rsmogura@softperience.eu>, PG Hackers <pgsql-hackers@postgresql.org>

Date: 2011-03-25T18:08:31Z

Lists: pgsql-hackers

On Mar 25, 2011, at 11:58 AM, Jim Nasby <jim@nasby.net> wrote:
> Related to that... after talking to Greg Smith at PGEast last night, he felt it would be very valuable just to profile how much time is being spent waiting/holding the freelist lock in a real environment. I'm going to see if we can do that on one of our slave databases.

Yeah, that would be great. Also, some LWLOCK_STATS output or oprofile output would be definitely be useful.

...Robert