Re: preloading indexes

Поиск
Список
Период
Сортировка
От
Тема Re: preloading indexes
Дата
Msg-id 20041103205613.ITAC27576.fed1rmmtao07.cox.net@CYGNUS
обсуждение исходный текст
Ответ на Re: preloading indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Thanks - this is what I was afraid of, but I may have to do this

Is there a good way to monitor what's in the cache?

j

<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 по дате отправления:

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