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

From: Greg Williamson <gwilliamson39(at)yahoo(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Queries seldomly take >4s while normally take <1ms?
Date: 2013-04-09 10:53:13
Message-ID: 1365504793.51584.YahooMailNeo@web125901.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message News Subsystem 2013-04-09 11:21:52
Previous Message Eduardo Morras 2013-04-09 10:05:11 Re: Backup advice