Re: [PERFORM] Upgrade to dual processor machine?

running 7.2.1 here

--

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

----- Original Message -----
From: "Doug McNaught" <doug(at)mcnaught(dot)org>
To: "Henrik Steffen" <steffen(at)city-map(dot)de>
Cc: <shridhar_daithankar(at)persistent(dot)co(dot)in>; <pgsql-general(at)postgresql(dot)org>; <pgsql-performance(at)postgresql(dot)org>
Sent: Thursday, November 14, 2002 9:50 PM
Subject: Re: [PERFORM] [GENERAL] Upgrade to dual processor machine?

> "Henrik Steffen" <steffen(at)city-map(dot)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 run VACUUM
> > every night in an automated manner. For tables with few modifications, VACUUM should be run less frequently. The command
exclusively
> > 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
>