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

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 17:31:58
Message-ID: 1122053518.21502.180.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

On Fri, 2005-07-22 at 12:20 -0400, Tom Lane wrote:
> I think that this refutes the original scheme of using the same fuzz
> factor for both startup and total cost comparisons, and therefore
> propose the attached patch.
>
> Comments?

Looks good. I think it explains a few other wierd perf reports also.

Best Regards, Simon Riggs

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vivek Khera 2005-07-22 17:34:49 Re: Problems compiling Postgresql 8.0.3 on 10.4
Previous Message Andrew Dunstan 2005-07-22 16:55:38 Re: Buildfarm failure - pl/tcl on snake

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-07-22 18:06:17 Re: [HACKERS] Planner doesn't look at LIMIT?
Previous Message Joshua D. Drake 2005-07-22 17:11:25 Re: [PATCHES] COPY FROM performance improvements