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

Re: How to monitor resources on Linux.

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to monitor resources on Linux.
Date: 2007-08-28 19:55:54
Message-ID: 20070828195554.GB1683@phlogiston.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, Aug 28, 2007 at 03:40:03PM -0400, John R Allgood wrote:
> lot of activity as compared to the other databases. We run VACUUM at 
> midday VACUUM FULL at night, VACUUM ANALYZE on weekends.

If you are running VACUUM often enough, then you should _never_ need
VACUUM FULL.  And weekly VACUUM ANALYSE is probably too infrequent. 

A

-- 
Andrew Sullivan  | ajs(at)crankycanuck(dot)ca
"The year's penultimate month" is not in truth a good way of saying
November.
		--H.W. Fowler

In response to

Responses

pgsql-admin by date

Next:From: John R AllgoodDate: 2007-08-28 20:14:09
Subject: Re: How to monitor resources on Linux.
Previous:From: John R AllgoodDate: 2007-08-28 19:40:03
Subject: Re: How to monitor resources on Linux.

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