Re: Queries seldomly take >4s while normally take <1ms?

Поиск
Список
Период
Сортировка
От Greg Williamson
Тема Re: Queries seldomly take >4s while normally take <1ms?
Дата
Msg-id 1365504793.51584.YahooMailNeo@web125901.mail.ne1.yahoo.com
обсуждение исходный текст
Ответ на Queries seldomly take >4s while normally take <1ms?  (Christian Hammers <ch@lathspell.de>)
Ответы Re: Queries seldomly take >4s while normally take <1ms?
Список pgsql-general
Christian --

<original text snip because this POS editor won't let me properly edit>

postgres version ?

type of replication ?

changes from postgres config defaults ?

Do they happen more at peak usage, semi regularly or sporadically ?

Possibly some sporadic postgres process such as checkpoints of autovac processes kicking off. Do your logs show
anything? 

HTH,

Greg W.



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

Предыдущее
От: Eduardo Morras
Дата:
Сообщение: Re: Backup advice
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Tablename.columnname%TYPE in Types On PostgreSQL 9.2