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 |
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 |
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 |