Re: preloading indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: stuff(at)opensourceonline(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: preloading indexes
Date: 2004-11-03 20:53:09
Message-ID: 16805.1099515189@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

<stuff(at)opensourceonline(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2004-11-03 20:53:16 Re: preloading indexes
Previous Message stuff 2004-11-03 20:19:43 Re: preloading indexes