Re: preloading indexes - Mailing list pgsql-performance

From Tom Lane
Subject Re: preloading indexes
Date
Msg-id 16805.1099515189@sss.pgh.pa.us
Whole thread Raw
In response to Re: preloading indexes  (<stuff@opensourceonline.com>)
Responses Re: preloading indexes  (<stuff@opensourceonline.com>)
Re: preloading indexes  (Mike Benoit <ipso@snappymail.ca>)
List pgsql-performance
<stuff@opensourceonline.com> writes:
> The caching appears to disappear overnight.

You've probably got cron jobs that run late at night and blow out your
kernel disk cache by accessing a whole lot of non-Postgres stuff.
(A nightly disk backup is one obvious candidate.)  The most likely
solution is to run some cron job a little later to exercise your
database and thereby repopulate the cache with Postgres files before
you get to work ;-)

            regards, tom lane

pgsql-performance by date:

Previous
From:
Date:
Subject: Re: preloading indexes
Next
From: Andrew Sullivan
Date:
Subject: Re: preloading indexes