Skip site navigation (1)
Skip section navigation (2)
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.
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 28 Aug 2007 16:14:09 -0400
- Message-id: <46D48211.8010806@the-allgoods.net> <text/plain>
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_ needVACUUM FULL. And weekly VACUUM ANALYSE is probably too infrequent.A
- Follow-Ups:
- Re: How to monitor resources on Linux.
- From: Andrew Sullivan
- Re: How to monitor resources on Linux.
- References:
- How to monitor resources on Linux.
- From: John R Allgood
- Re: How to monitor resources on Linux.
- From: Tom Lane
- Re: How to monitor resources on Linux.
- From: John R Allgood
- Re: How to monitor resources on Linux.
- From: Alvaro Herrera
- Re: How to monitor resources on Linux.
- From: John R Allgood
- Re: How to monitor resources on Linux.
- From: Andrew Sullivan
- How to monitor resources on Linux.
- Prev by Date: Re: How to monitor resources on Linux.
- Next by Date: Re: How to monitor resources on Linux.
- Previous by thread: Re: How to monitor resources on Linux.
- Next by thread: Re: How to monitor resources on Linux.
- Indexes: