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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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