From: ohp@pyrenet.fr
To: vathakar@banas.guj.nic.in
Cc: pgsql-performance@postgresql.org
Subject: Re: Slow in morning hours
Date: Fri, 20 Feb 2004 15:51:00 +0100 (MET)
Message-ID: <Pine.UW2.4.53.0402201550200.10872@server.pyrenet.fr> (raw)
In-Reply-To: <40361DBE.3636.10FEBF@localhost>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78508C847@vt-pe2550-001.vantage.vantage.com>
<40361DBE.3636.10FEBF@localhost>
Have you tried VACUUM ANALYZE at least one a day?
Regards
On Fri, 20 Feb 2004 vathakar@banas.guj.nic.in wrote:
> Date: Fri, 20 Feb 2004 14:46:15 +0530
> From: vathakar@banas.guj.nic.in
> To: pgsql-performance@postgresql.org
> Cc: vathakar@banas.guj.nic.in
> Subject: [PERFORM] Slow in morning hours
>
> Hi All,
>
> I am using Linux 7.2 and postgresql 7.2.
>
> Our Office hours are over at 6pm but we use to keep our server
> running 24 hours a day. On the second day morning, Our PGSQL
> Server becomes very slow.
>
> 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?
>
> Please any any idea to get relief daily morning problem !!
>
> Thanxs,
> Vishal
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
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: ohp@pyrenet.fr, vathakar@banas.guj.nic.in
Subject: Re: Slow in morning hours
In-Reply-To: <Pine.UW2.4.53.0402201550200.10872@server.pyrenet.fr>
* 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