Re: Performance woes - Mailing list pgsql-general

From Tom Lane
Subject Re: Performance woes
Date
Msg-id 1328.1134440573@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance woes  (Benjamin Smith <lists@benjamindsmith.com>)
List pgsql-general
Benjamin Smith <lists@benjamindsmith.com> writes:
> And, this dropped the query time from between 2.2-30 seconds all the
> way down to just 55-ish ms, without any new indexes! What's more, the
> improvement came from a move of a block I thought more or less
> unimportant!

> // tries to put jaw back into mouth //

Yeah ... we really need to fix the planner so it can do this for you,
as it does with regular inner joins ...

            regards, tom lane

pgsql-general by date:

Previous
From: Benjamin Smith
Date:
Subject: Re: Performance woes
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Quick hack: permissions generator