Re: Queries sometimes take 1000 times the normal time

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: "Anders K(dot) Pedersen" <akp(at)cohaesio(dot)com>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Queries sometimes take 1000 times the normal time
Date: 2003-08-28 01:14:19
Message-ID: 1062033258.71328.2.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Stephan Szabo 2003-08-28 01:22:23 Re: Simple queries take forever to run
Previous Message Neil Conway 2003-08-28 00:11:19 Re: Simple queries take forever to run