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.