From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-performance@postgresql.org
Subject: Re: Slow in morning hours
Date: Fri, 20 Feb 2004 07:19:45 -0500
Message-ID: <20040220121945.GB15383@phlogiston.dyndns.org> (raw)
In-Reply-To: <40361DBE.3636.10FEBF@localhost>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78508C847@vt-pe2550-001.vantage.vantage.com>
<40361DBE.3636.10FEBF@localhost>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: Slow in morning hours
In-Reply-To: <20040220121945.GB15383@phlogiston.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox