Horton

Re: tuning questions

Josh Berkus <josh@agliodbs.com>

View thread View on postgr.es
From: Josh Berkus <josh@agliodbs.com>
To: "scott.marlowe" <scott.marlowe@ihs.com>, Jack Coates <jack@lyris.com>
Cc: <pgsql-performance@postgresql.org>
Date: 2003-12-04T18:03:52Z
Lists: pgsql-hackers, pgsql-performance 
Scott,

> Just to add to what the others have said here, you probably want to run 
> the pg_autovacuum daemon in the background.  It comes with 7.4 but will 
> work fine with 7.3.  

I don't recommend using pg_autovacuum with a data transformation task.   pg_av 
is designed for "regular use" not huge batch tasks.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco