Re: Oddly slow queries

Поиск
Список
Период
Сортировка
От PFC
Тема Re: Oddly slow queries
Дата
Msg-id op.t9odybcgcigqcu@apollo13.peufeu.com
обсуждение исходный текст
Ответ на Oddly slow queries  (Thomas Spreng <spreng@socket.ch>)
Ответы Re: Oddly slow queries  (Thomas Spreng <spreng@socket.ch>)
Список pgsql-performance
> The queries in question (select's) occasionally take up to 5 mins even
> if they take ~2-3 sec under "normal" conditions, there are no sequencial
> scans done in those queries. There are not many users connected (around
> 3, maybe) to this database usually since it's still in a testing phase.
> I tried to hunt down the problem by playing around with resource usage
> cfg options but it didn't really made a difference.

    Could that be caused by a CHECKPOINT ?

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

Предыдущее
От: david@lang.hm
Дата:
Сообщение: Re: Performance increase with elevator=deadline
Следующее
От: Thomas Spreng
Дата:
Сообщение: Re: Oddly slow queries