Re: preloading indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: preloading indexes
Дата
Msg-id 16805.1099515189@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: preloading indexes  (<stuff@opensourceonline.com>)
Ответы Re: preloading indexes  (<stuff@opensourceonline.com>)
Re: preloading indexes  (Mike Benoit <ipso@snappymail.ca>)
Список 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 по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: preloading indexes
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: preloading indexes