Skip site navigation (1) Skip section navigation (2)

Re: Patch: Tie stats options to autovacuum in postgresql.conf

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: David Wheeler <david(at)kineticode(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Patch: Tie stats options to autovacuum in postgresql.conf
Date: 2006-09-28 23:39:15
Message-ID: 20060928233915.GG34238@nasby.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Thu, Sep 28, 2006 at 03:07:39PM -0700, David Wheeler wrote:
> PostgreSQLers,
> 
> I just ran into an issue where a client thought that autovacuum was  
> running but it wasn't. This is because it's not fatal when autovacuum  
> is on but stats_start_collector and/or stats_row_level is off. I  
> suspect that there's a reason that it's not fatal, so I thought that  
> it might be useful to give folks just a little bit of help by telling  
> them in postgresql.conf that they need to enable them in order for  
> autovacuum to work.

+1. I was just at a client today that had run into this problem.

Actually, I'm in favor of refusing to start if autovac is on but the
proper stats settings aren't. I'd rather that then people ending up with
bloated databases and crappy performance.
-- 
Jim Nasby                                            jim(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

In response to

Responses

pgsql-hackers by date

Next:From: David E. WheelerDate: 2006-09-28 23:46:12
Subject: Re: Patch: Tie stats options to autovacuum in postgresql.conf
Previous:From: Jim C. NasbyDate: 2006-09-28 23:32:11
Subject: Re: New version of money type

pgsql-patches by date

Next:From: David E. WheelerDate: 2006-09-28 23:46:12
Subject: Re: Patch: Tie stats options to autovacuum in postgresql.conf
Previous:From: David WheelerDate: 2006-09-28 22:07:39
Subject: Patch: Tie stats options to autovacuum in postgresql.conf

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group