On Sun, Feb 28, 2010 at 8:09 PM, Plugge, Joe R. <JRPlu...@west.com> wrote:What kind of drive system do you have? That's far more important than
> 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.
CPU and RAM.
Let's look at a two pronged attack. 1: What can you maybe do to
update row set field1='xyz' where id=4;
And you can combine those updates, that's a big savings.
Can you benefit from HOT updates by removing some indexes? Updating
2: Vacuum tuning.
> Currently I am using only defaults for autovac.
> #autovacuum_vacuum_cost_delay = 20msis very high for a busy system with a powerful io subsystem. I run my
production servers with 1ms to 4ms so they can keep up.
Lastly there are some settings you can make per table for autovac you
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.