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

Re: Freebsd vs linux and hardware question

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Dror Matalon <dror(at)zapatec(dot)com>, sfpug(at)postgresql(dot)org
Subject: Re: Freebsd vs linux and hardware question
Date: 2003-09-22 17:24:29
Message-ID: 200309221024.29208.josh@agliodbs.com (view raw or flat)
Thread:
Lists: sfpug
Dror,

> But actually one of the big problems was solved when we ran VACUUM FULL
> on a problematic table. It shrank from 100 Megs to 6 Megs which on a
> local disk isn't as big a problem as on a NAS.
>
> We're also now running VACUUM ANALYZE on the table every five minutes
> instead of once a day and that helps too.

What is your setting for max_fsm_pages?   Have you compared it against the 
results of logged VACUUM VERBOSE?  And I'd be surprised if running VACUUM 
ANALYZE ever 5 minutes is necessary ... VACUUM should do, with ANAYLZE maybe 
once a day, unless your users are big on changing a large % of rows at once.

Finally, what about REINDEX?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

sfpug by date

Next:From: AdityaDate: 2003-09-22 17:42:14
Subject: Re: Freebsd vs linux and hardware question
Previous:From: Dror MatalonDate: 2003-09-20 19:02:34
Subject: Re: Freebsd vs linux and hardware question

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