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

From: Greg Stark <stark(at)mit(dot)edu>
To: Peter Geoghegan <pg(at)heroku(dot)com>
Cc: Ants Aasma <ants(at)cybertec(dot)at>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Clock sweep not caching enough B-Tree leaf pages?
Date: 2014-04-18 01:50:20
Message-ID: CAM-w4HNOHyB9DL5bA9BrzZZxZWWVXctXv2COJgt9gYCe4LH=AA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Apr 17, 2014 at 4:48 PM, Peter Geoghegan <pg(at)heroku(dot)com> wrote:
> Although I will add that not caching highly useful inner pages for the
> medium term, because that index isn't being used at all for 5 minutes
> probably is very bad. Using the 4,828 buffers that it would take to
> store all the inner pages (as in my large primary index example) to go
> store something else is probably penny wise and pound foolish.

But there could easily be 20 unused indexes for every 1 index that is
being used.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2014-04-18 01:50:59 Re: [bug fix] pg_ctl always uses the same event source
Previous Message Greg Stark 2014-04-18 01:40:22 Re: How can we make beta testing better?