Re: Oddly slow queries

From: PFC <lists(at)peufeu(dot)com>
To: "Thomas Spreng" <spreng(at)socket(dot)ch>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Oddly slow queries
Date: 2008-04-15 23:24:01
Message-ID: op.t9odybcgcigqcu@apollo13.peufeu.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> The queries in question (select's) occasionally take up to 5 mins even
> if they take ~2-3 sec under "normal" conditions, there are no sequencial
> scans done in those queries. There are not many users connected (around
> 3, maybe) to this database usually since it's still in a testing phase.
> I tried to hunt down the problem by playing around with resource usage
> cfg options but it didn't really made a difference.

Could that be caused by a CHECKPOINT ?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Thomas Spreng 2008-04-16 04:07:04 Re: Oddly slow queries
Previous Message david 2008-04-15 19:08:31 Re: Performance increase with elevator=deadline