Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-performance by date

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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group