how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer
Дата
Msg-id AANLkTin0eIqjfIF2KoUcclnH_86X6aqOh5yNygu6f4pf@mail.gmail.com
обсуждение исходный текст
Ответы Re: how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer  (Craig Ringer <craig@postnewspapers.com.au>)
Список pgsql-performance
Hi,

this is not really a performance question , sorry if its bit irrelevant
to be posted here. We have a development environment and we want
to optimize the non-database parts of the application. The problem is
that subsequent run of  queries are execute very fast and makes the
performance analysis a trivial problem. We want that the subsequent runs
of query should take similar times as the first run so that we can work
on the optimizing the calling patterns to the database.

regds
Rajesh Kumar Mallah.

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

Предыдущее
От: Deborah Fuentes
Дата:
Сообщение: Extremely high CPU usage when building tables
Следующее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: Extremely high CPU usage when building tables