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

Patch: Tie stats options to autovacuum in postgresql.conf

From: David Wheeler <david(at)kineticode(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Patch: Tie stats options to autovacuum in postgresql.conf
Date: 2006-09-28 22:07:39
Message-ID: C1A99EB4-2A03-42B3-8BB6-32BECF7BC9E0@kineticode.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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.

If this patch is not correctly formatted or against the proper file,  
please let me know and I'll make the necessary modifications.

Thanks,

David


Attachment: vacuam_stats.patch
Description: application/octet-stream (827 bytes)

Responses

pgsql-hackers by date

Next:From: Paul B. AndersonDate: 2006-09-28 22:11:55
Subject: Stored procedure array limits
Previous:From: Josh BerkusDate: 2006-09-28 22:03:32
Subject: Re: JAVA Support

pgsql-patches by date

Next:From: Jim C. NasbyDate: 2006-09-28 23:39:15
Subject: Re: Patch: Tie stats options to autovacuum in postgresql.conf
Previous:From: BenDate: 2006-09-28 21:24:43
Subject: Re: contrib/levenshtein() has a bug?

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