pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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)



view thread (5+ messages)  latest in thread

Message-ID: <Pine.UW2.4.53.0402201550200.10872@server.pyrenet.fr>
Permalink:  ../Pine.UW2.4.53.0402201550200.10872@server.pyrenet.fr/
Also on:    postgresql.org/message-id/Pine.UW2.4.53.0402201550200.10872@server.pyrenet.fr

 · 

reply

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