Re: query optimization scenarios 17,701 times faster!!! - Mailing list pgsql-hackers

From Tom Lane
Subject Re: query optimization scenarios 17,701 times faster!!!
Date
Msg-id 10365.1051153190@sss.pgh.pa.us
Whole thread Raw
In response to query optimization scenarios 17,701 times faster!!!  ("Robert Dyas" <rdyas@adelphia.net>)
Responses Re: query optimization scenarios 17,701 times faster!!!  ("Robert Dyas" <rdyas@adelphia.net>)
List pgsql-hackers
"Robert Dyas" <rdyas@adelphia.net> writes:
> The following is a list of query pairs (one fast, one slow) that must
> produce identical results by definition (and do), but have very different
> execution times.

With no details about the table schemas, nor the EXPLAIN ANALYZE output
data, I really wonder how you expect any intelligent comments.  We are
programmers, not mind-readers.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: bit strings - anyone working on them?
Next
From: Sailesh Krishnamurthy
Date:
Subject: Re: Are we losing momentum?