| From: | Greg Sabino Mullane <greg(at)turnstep(dot)com> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Better default_statistics_target |
| Date: | 2007-11-14 04:38:08 |
| Message-ID: | 1195015088.24501.58.camel@greg-laptop |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Per a recent bug in which the planner can behave very differently at <
100, and accounting for the fact that analyze is still plenty fast on
today's systems even at a tenfold increase, attached is a patch to
change default_statistics_target from 10 to 100.
| Attachment | Content-Type | Size |
|---|---|---|
| better_default_stats.patch | text/x-patch | 3.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Webb Sprague | 2007-11-14 04:47:26 | Re: Simplifying Text Search |
| Previous Message | Tom Lane | 2007-11-14 03:50:41 | Re: a tsearch2 (8.2.4) dictionary that only filters out stopwords |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-11-14 05:00:06 | Re: Better default_statistics_target |
| Previous Message | Tom Lane | 2007-11-14 03:50:41 | Re: a tsearch2 (8.2.4) dictionary that only filters out stopwords |