Re: Slow in morning hours - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: Slow in morning hours
Date
Msg-id 20040220121945.GB15383@phlogiston.dyndns.org
Whole thread Raw
In response to Slow in morning hours  (<vathakar@banas.guj.nic.in>)
List pgsql-performance
On Fri, Feb 20, 2004 at 02:46:15PM +0530, vathakar@banas.guj.nic.in wrote:
>
> After continuous usage of one hour, It gradually starts responding
> faster ! This has become every day routine !
>
> do u have any idea related to this !!!! Is there any other reason that I
> need to check up?

What's running on the machine during those hours?  Maybe VACUUM is
sucking up all your bandwidth.  Or your backups.  Or some other
cron job.

Note that 7.2 is pretty old.  There are several performance
improvements in subsequent versions.

A

--
Andrew Sullivan

pgsql-performance by date:

Previous
From:
Date:
Subject: Slow in morning hours
Next
From: Bill Moran
Date:
Subject: Re: Slow in morning hours