Re: [HACKERS] Planner doesn't look at LIMIT?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Dawid Kuroczko <qnex42(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Planner doesn't look at LIMIT?
Date: 2005-07-22 18:06:17
Message-ID: 7214.1122055577@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-07-22 19:03:13 Re: Imprecision of DAYS_PER_MONTH
Previous Message Josh Berkus 2005-07-22 18:01:07 Re: Checkpoint cost, looks like it is WAL/CRC

Browse pgsql-performance by date

  From Date Subject
Next Message Luke Lonergan 2005-07-22 19:28:43 Re: [PATCHES] COPY FROM performance improvements
Previous Message Simon Riggs 2005-07-22 17:31:58 Re: [HACKERS] Planner doesn't look at LIMIT?