Re: [HACKERS] Patch: Tie stats options to autovacuum in

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: David Wheeler <david(at)kineticode(dot)com>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] Patch: Tie stats options to autovacuum in
Date: 2006-10-03 00:40:06
Message-ID: 200610030040.k930e6Z24030@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


Modified wording patch applied. Thanks.

---------------------------------------------------------------------------

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.
>
> 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, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

Attachment Content-Type Size
/bjm/diff text/x-diff 841 bytes

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-10-03 00:40:20 Re: TM modificator don't work? to_char
Previous Message Sergey E. Koposov 2006-10-03 00:36:02 Re: TM modificator don't work? to_char

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2006-10-03 00:41:56 Re: Patch: Tie stats options to autovacuum in
Previous Message Josh Berkus 2006-10-03 00:02:45 Re: Faster StrNCpy