| From: | "Robert Haas" <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com> |
| Cc: | "Greg Smith" <gsmith(at)gregsmith(dot)com>, "Gregory Stark" <stark(at)enterprisedb(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Josh Berkus" <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: default statistics target testing (was: Simple postgresql.conf wizard) |
| Date: | 2008-12-05 19:11:56 |
| Message-ID: | 603c8f070812051111r56dcf0e5hcd505b41c622aab9@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> On Fri, Dec 5, 2008 at 7:24 PM, Greg Smith <gsmith(at)gregsmith(dot)com> wrote:
>> comparing to 8.2.9 results:
>> - q1 was 32% slower with dst = 10, 33% slower with dst = 1000
>> - other queries were 19% slower with dst = 10, 25% slower with dst = 1000
>
> You mean that HEAD is slower than 8.2.9 or I don't understand
> correctly what you wrote?
Correct. As compared with 8.2.9, ANALYZE was substantially faster,
but query planning was significantly slower.
Thanks also to Greg for reposting my emails. I didn't even realize I
hadn't sent them to the list.
...Robert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Smet | 2008-12-05 19:16:59 | Re: default statistics target testing (was: Simple postgresql.conf wizard) |
| Previous Message | Martin Pitt | 2008-12-05 18:44:36 | Re: Versioned mo file installation |