From: | Vivek Khera <vivek(at)khera(dot)org> |
---|---|
To: | Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Default autovacuum settings too conservative |
Date: | 2006-02-06 20:00:12 |
Message-ID: | 116B6671-FAAA-453C-A52A-26B077373BB4@khera.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-performance |
On Feb 1, 2006, at 4:37 PM, Matthew T. O'Connor wrote:
> As far I as I know, we are still looking for real world feedback.
> 8.1 is the first release to have the integrated autovacuum. The
> thresholds in 8.1 are a good bit less conservative than the
> thresholds in the contrib version. The contrib thresholds were
> universally considered WAY to conservative, but that was somewhat
> necessary since you couldn't set them on a per table basis as you
> can in 8.1. If we continue to hear from people that the current
> 8.1 default thresholds are still to conservative we can look into
> lowering them.
I spent the weekend researching and pondering this topic as well.
For me the per-table tuning is vital, since I have some tables that
are very small and implement a queue (ie, update very often several
million times per day and have at most 10 or so rows), some that are
fairly stable with O(10k) rows which update occasionally, and a
couple of tables that are quite large: 20 million rows which updates
a few million times per day and inserts a few thousand, and another
table with ~275 million rows in which we insert and update roughly 3
million per day.
The 40% overhead would kill these large tables both in terms of
performance and disk usage. I'm pondering a global 10% and having the
big tables at or below 1% based on the rate of change.
Is there a way to make the autovacuum process log more verbosely
while leaving the rest of the logging minimal? This would help tune it.
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Browne | 2006-02-06 22:15:16 | Re: Default autovacuum settings too conservative |
Previous Message | Scott Marlowe | 2006-02-06 18:37:53 | Re: autovacuum |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Lazarus | 2006-02-06 20:36:15 | Re: execution plan : Oracle vs PostgreSQL |
Previous Message | Albert Cervera Areny | 2006-02-06 08:30:30 | Re: Storing Digital Video |