Joe wrote:
> I have a very busy system that takes about 9 million inserts per day and each
> record gets
> updated at least once after the insert (all for the one same table), there
> are other tables that
> get hit but not as severely. As suspected I am having a problem with table
> bloat. Any advice
> on how to be more aggressive with autovacuum? I am using 8.4.1. My machine
> has 4 Intel
> Xeon 3000 MHz Processors with 8 GB of Ram.
>
> Currently I am using only defaults for autovac.
>
> shared_buffers = 768MB # min 128kB
> work_mem = 1MB # min 64kB
> maintenance_work_mem = 384MB
<snip of default config settings>
Operating system ?
Any messages in logs ?
Greg W.
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
