Re: default statistics target testing (was: Simple postgresql.conf wizard) - Mailing list pgsql-hackers

From Robert Haas
Subject Re: default statistics target testing (was: Simple postgresql.conf wizard)
Date
Msg-id 603c8f070812051111r56dcf0e5hcd505b41c622aab9@mail.gmail.com
Whole thread Raw
In response to Re: default statistics target testing (was: Simple postgresql.conf wizard)  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Responses Re: default statistics target testing (was: Simple postgresql.conf wizard)  ("Guillaume Smet" <guillaume.smet@gmail.com>)
List pgsql-hackers
> On Fri, Dec 5, 2008 at 7:24 PM, Greg Smith <gsmith@gregsmith.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


pgsql-hackers by date:

Previous
From: Martin Pitt
Date:
Subject: Re: Versioned mo file installation
Next
From: "Guillaume Smet"
Date:
Subject: Re: default statistics target testing (was: Simple postgresql.conf wizard)