Re: Help in avoiding a query 'Warm-Up' period/shared buffer

Поиск
Список
Период
Сортировка
От David Lang
Тема Re: Help in avoiding a query 'Warm-Up' period/shared buffer
Дата
Msg-id Pine.LNX.4.62.0601051848510.11046@qnivq.ynat.uz
обсуждение исходный текст
Ответ на Re: Help in avoiding a query 'Warm-Up' period/shared buffer cache  (Mark Liberman <mliberman@mixedsignals.com>)
Ответы Re: Help in avoiding a query 'Warm-Up' period/shared buffer
Список pgsql-performance
Дерево обсуждения 
On Thu, 5 Jan 2006, Mark Liberman wrote:

> Obviously, I will be testing this - but it might take a few days, as I haven't
> figure out how to simulate the "period of inactivity" to get the data flushed
> out of the cache ... so I have to run this each morning.

cat large_file >/dev/null

will probably do a pretty good job of this (especially if large_file is
noticably larger then the amount of ram you have)

David Lang

В списке pgsql-performance по дате отправления:

Предыдущее
От: Mark Liberman
Дата:
Сообщение: Re: Help in avoiding a query 'Warm-Up' period/shared buffer cache
Следующее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: Help in avoiding a query 'Warm-Up' period/shared buffer cache