Re: Oddly slow queries - Mailing list pgsql-performance

From PFC
Subject Re: Oddly slow queries
Date
Msg-id op.t9odybcgcigqcu@apollo13.peufeu.com
Whole thread Raw
In response to Oddly slow queries  (Thomas Spreng <spreng@socket.ch>)
Responses Re: Oddly slow queries  (Thomas Spreng <spreng@socket.ch>)
List 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 ?

pgsql-performance by date:

Previous
From: david@lang.hm
Date:
Subject: Re: Performance increase with elevator=deadline
Next
From: Thomas Spreng
Date:
Subject: Re: Oddly slow queries