Skip site navigation (1) Skip section navigation (2)

Re: Slow in morning hours

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow in morning hours
Date: 2004-02-20 12:19:45
Message-ID: 20040220121945.GB15383@phlogiston.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, Feb 20, 2004 at 02:46:15PM +0530, vathakar(at)banas(dot)guj(dot)nic(dot)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  

In response to

pgsql-performance by date

Next:From: Bill MoranDate: 2004-02-20 13:48:54
Subject: Re: Slow in morning hours
Previous:From: vathakarDate: 2004-02-20 09:16:15
Subject: Slow in morning hours

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group