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

Re: Slow in morning hours

From: ohp(at)pyrenet(dot)fr
To: vathakar(at)banas(dot)guj(dot)nic(dot)in
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow in morning hours
Date: 2004-02-20 14:51:00
Message-ID: Pine.UW2.4.53.0402201550200.10872@server.pyrenet.fr (view raw or flat)
Thread:
Lists: pgsql-performance
Have you tried VACUUM ANALYZE at least one a day?

Regards
On Fri, 20 Feb 2004 vathakar(at)banas(dot)guj(dot)nic(dot)in wrote:

> Date: Fri, 20 Feb 2004 14:46:15 +0530
> From: vathakar(at)banas(dot)guj(dot)nic(dot)in
> To: pgsql-performance(at)postgresql(dot)org
> Cc: vathakar(at)banas(dot)guj(dot)nic(dot)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(at)postgresql(dot)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(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)

In response to

pgsql-performance by date

Next:From: Bill MoranDate: 2004-02-20 15:35:32
Subject: cacheable stored functions?
Previous:From: Neil ConwayDate: 2004-02-20 14:34:31
Subject: Re: Slow response of PostgreSQL

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