Re: Queries sometimes take 1000 times the normal time - Mailing list pgsql-performance

From Rod Taylor
Subject Re: Queries sometimes take 1000 times the normal time
Date
Msg-id 1062033258.71328.2.camel@jester
Whole thread Raw
In response to Queries sometimes take 1000 times the normal time  ("Anders K. Pedersen" <akp@cohaesio.com>)
List pgsql-performance
> Currently there's only a few users in the database for testing purposes,
> and most of the time the user lookup's take 2-3 ms (I have syslog'ing of
> queries and duration turned on), but several times per hour the duration
> for one of the queries is 2-3 seconds (1000 times larger), while the
> surrounding lookups take the usual 2-3 ms.

Are there any other jobs running at the time of these excessive queries?

Attachment

pgsql-performance by date:

Previous
From: matt
Date:
Subject: Re: Hardware recommendations to scale to silly load
Next
From: Stephan Szabo
Date:
Subject: Re: Simple queries take forever to run