Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Planner doesn't look at LIMIT? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PERFORM] Planner doesn't look at LIMIT?
Date
Msg-id 7214.1122055577@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PERFORM] Planner doesn't look at LIMIT?  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: [PERFORM] Planner doesn't look at LIMIT?
List pgsql-hackers
Tree view 
Simon Riggs <simon@2ndquadrant.com> writes:
> Looks good. I think it explains a few other wierd perf reports also.

Could be.  I went back to look at Sam Mason's report about three weeks
ago, and it definitely seems to explain his issue.  The "fuzzy cost
comparison" logic is new in 8.0 so it hasn't had all that much
testing...

            regards, tom lane

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Checkpoint cost, looks like it is WAL/CRC
Next
From: Bruce Momjian
Date:
Subject: Re: Imprecision of DAYS_PER_MONTH