From: Greg Williamson <gwilliamson39@yahoo.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Autovacuum Tuning advice
Date: Sun, 28 Feb 2010 23:08:02 -0800 (PST)
Message-ID: <841727.16396.qm@web46102.mail.sp1.yahoo.com> (raw)
In-Reply-To: <E2160D87-855A-49E9-8704-D6389A76C2F3@mimectl>
References: <4AB8D9AA.6050007@ummon.com>
<4AB8E145.4040901@squeakycode.net>
<E2160D87-855A-49E9-8704-D6389A76C2F3@mimectl>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gwilliamson39@yahoo.com
Subject: Re: Autovacuum Tuning advice
In-Reply-To: <841727.16396.qm@web46102.mail.sp1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox