Re: Clock sweep not caching enough B-Tree leaf pages? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Clock sweep not caching enough B-Tree leaf pages?
Date
Msg-id 18291.1397690940@sss.pgh.pa.us
Whole thread Raw
In response to Re: Clock sweep not caching enough B-Tree leaf pages?  (Peter Geoghegan <pg@heroku.com>)
List pgsql-hackers
Peter Geoghegan <pg@heroku.com> writes:
> My immediate concern here is getting recognition of the importance of
> weighing frequency of access in *some* way.

That's a completely content-free statement; certainly the existing
clock-sweep code is sensitive to frequency of access, as would be
any other algorithm we'd be likely to adopt.  It may well be that
we can do better than what we've got, but sweeping generalities
are unlikely to help us much.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql: Include planning time in EXPLAIN ANALYZE output.
Next
From: Bruce Momjian
Date:
Subject: Re: slow startup due to LWLockAssign() spinlock