Re: [BUGS] BUG #6426: Complex query runs 10 times longer with "LIMIT 20"

2012-02-01 Thread Andrew Schetinin
ham, > MD 20706 301-352-4657 (phone) 301-352-0437 (fax) a...@sesda2.com > > -- -- Andrew Schetinin

Re: [BUGS] BUG #6426: Complex query runs 10 times longer with "LIMIT 20"

2012-02-02 Thread Andrew Schetinin
query optimizer rearranges the order according to its logic. Now it appears that sometimes it may be important. Regards, Andrew On Wed, Feb 1, 2012 at 11:48 PM, Tom Lane wrote: > Andrew Schetinin writes: > > In my specific case, what I've seen from the query execution plans, is >