Re: How to monitor resources on Linux.

From: John R Allgood <jallgood(at)the-allgoods(dot)net>
To: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to monitor resources on Linux.
Date: 2007-08-28 20:14:09
Message-ID: 46D48211.8010806@the-allgoods.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We were running vacuum and vacuum full daily without the vaccum analyze
on weekends. After about 2 weeks the master database would slow down.
How often do you run VACUUM or are you using the autovacumm daemon.

Andrew Sullivan wrote:
> 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
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2007-08-28 20:24:43 Re: How to monitor resources on Linux.
Previous Message Andrew Sullivan 2007-08-28 19:55:54 Re: How to monitor resources on Linux.