Re: Proposed Query Planner TODO items - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Proposed Query Planner TODO items
Date
Msg-id 22262.1076353717@sss.pgh.pa.us
Whole thread Raw
In response to Re: Proposed Query Planner TODO items  (markw@osdl.org)
Responses Re: Proposed Query Planner TODO items  (markw@osdl.org)
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> If #19 is missing it's because Oleg & I could not get it to complete.  That 
> was also the query which we are most interested in testing.

Q19 doesn't seem to be particularly slow in either the 7.4 or 7.5 tests
--- there are many others with longer runtimes.  I speculate that what
is actually being run here is a modified Q19 query with the merge join
condition pulled out by hand.  The CVS-tip planner should be able to do
that for itself, though, and obtain essentially this same performance
with the per-spec query.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.4.1 release status - Turkish Locale
Next
From: Tom Lane
Date:
Subject: Re: Question on pg_dump