Re: Strange performance response for high load times

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Strange performance response for high load times
Дата
Msg-id 4A3A64CD0200002500027DB9@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Strange performance response for high load times  (Peter Alban <peter.alban2@gmail.com>)
Список pgsql-performance
Peter Alban <peter.alban2@gmail.com> wrote:

> Why is there such a big difference ?
>
> i.e. off peek times a simple select with where (on indexed column)
> and limit taks* 40 ms* during peek times it took *2 seconds*  - 50
> times slower !

If your high work_mem setting you may have been causing the OS to
discard cached data, causing disk reads where you normally get cache
hits, or even triggered swapping.  Either of those can easily cause a
difference of that magnitude, or more.

-Kevin

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

Предыдущее
От: Peter Alban
Дата:
Сообщение: Re: Strange performance response for high load times
Следующее
От: Bryce Ewing
Дата:
Сообщение: Re: Index Scan taking long time