| 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: | Whole Thread | Raw Message | 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 |