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

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 (view raw or flat)
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

pgsql-admin by date

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

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