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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Moran 2004-02-20 13:48:54 Re: Slow in morning hours
Previous Message vathakar 2004-02-20 09:16:15 Slow in morning hours