Re: Queries seldomly take >4s while normally take <1ms? - Mailing list pgsql-general

From Greg Williamson
Subject Re: Queries seldomly take >4s while normally take <1ms?
Date
Msg-id 1365504793.51584.YahooMailNeo@web125901.mail.ne1.yahoo.com
Whole thread Raw
In response to Queries seldomly take >4s while normally take <1ms?  (Christian Hammers <ch@lathspell.de>)
Responses Re: Queries seldomly take >4s while normally take <1ms?
List 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 by date:

Previous
From: Eduardo Morras
Date:
Subject: Re: Backup advice
Next
From: Albe Laurenz
Date:
Subject: Re: Tablename.columnname%TYPE in Types On PostgreSQL 9.2