Re: weird performances problem - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: weird performances problem
Date
Msg-id 20051117221314.GC26696@phlogiston.dyndns.org
Whole thread Raw
In response to weird performances problem  (Guillaume Smet <guillaume.smet@openwide.fr>)
Responses Re: weird performances problem
List pgsql-performance
On Thu, Nov 17, 2005 at 06:47:09PM +0100, Guillaume Smet wrote:
> queries are executed fast even if they are complicated but sometimes and
> for half an hour, we have a general slow down.

Is it exactly half an hour?  What changes at the time that happens
(i.e. what else happens on the machine?).  Is this a time, for
example, when logrotate is killing your I/O with file moves?

A
--
Andrew Sullivan  | ajs@crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what
you told them to.  That actually seems sort of quaint now.
        --J.D. Baldwin

pgsql-performance by date:

Previous
From: William Yu
Date:
Subject: Re: Hardware/OS recommendations for large databases (
Next
From: Michael Fuhr
Date:
Subject: Re: Perl DBD and an alarming problem