Re: Performance Tuning and Disk Cache

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: Performance Tuning and Disk Cache
Дата
Msg-id 9e4684ce0703180618m33fe9ec4v3007a673d28df591@mail.gmail.com
обсуждение исходный текст
Ответ на Performance Tuning and Disk Cache  (Barry Moore <barry.moore@genetics.utah.edu>)
Список pgsql-performance
On 3/18/07, Barry Moore <barry.moore@genetics.utah.edu> wrote:
> Does anyone know how I can repeatedly run the same query in the
> "worst case scenario" of no postgres data in the disk cache (e.g.,
> clear the page cache or force it to be ignored)?

try to disconnect from postgresql, reconnect, rerun the query.
if it doesn't help - you can try unmounting filesystem which contains
postgresql data, and remounting it again. of course with postgresql
shutdown.

depesz

--
http://www.depesz.com/ - nowy, lepszy depesz

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

Предыдущее
От: Barry Moore
Дата:
Сообщение: Performance Tuning and Disk Cache
Следующее
От: David Boreham
Дата:
Сообщение: Re: Performance Tuning and Disk Cache