Re: [PERFORM] Upgrade to dual processor machine? - Mailing list pgsql-general

From Doug McNaught
Subject Re: [PERFORM] Upgrade to dual processor machine?
Date
Msg-id m3heejq3il.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Re: [PERFORM] Upgrade to dual processor machine?  ("Henrik Steffen" <steffen@city-map.de>)
List pgsql-general
"Henrik Steffen" <steffen@city-map.de> writes:

> This is what it says in the manual and what I have been doing until today:
>
> "You should run VACUUM periodically to clean out expired rows. For tables that are heavily modified, it is useful to
runVACUUM 
> every night in an automated manner. For tables with few modifications, VACUUM should be run less frequently. The
commandexclusively 
> locks the table while processing. "

The "exclusive lock" part is no longer true as of 7.2.X--it is now
much cheaper to run VACUUM.  What version were you running again?

-Doug

pgsql-general by date:

Previous
From: "Henrik Steffen"
Date:
Subject: Re: [PERFORM] Upgrade to dual processor machine?
Next
From: "Josh Berkus"
Date:
Subject: Re: [PERFORM] Upgrade to dual processor machine?