Re: [HACKERS] Solution for LIMIT cost estimation - Mailing list pgsql-hackers

From Chris Bitmead
Subject Re: [HACKERS] Solution for LIMIT cost estimation
Date
Msg-id 38A73B6C.74D38DB5@nimrod.itg.telecom.com.au
Whole thread Raw
In response to Solution for LIMIT cost estimation  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] Solution for LIMIT cost estimation
List pgsql-hackers
Tom Lane wrote:

> I have currently got it working (I think; not too well tested yet)
> using the proposal I offered before of "pay attention to the size
> of LIMIT, but ignore OFFSET", so that the same query plan will be
> derived from similar queries with different OFFSETs.  Does anyone
> have a substantial gripe with that compromise?

Would offset be any use if you did make use of it?


pgsql-hackers by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: [HACKERS] Solution for LIMIT cost estimation
Next
From: Don Baccus
Date:
Subject: Re: [HACKERS] Solution for LIMIT cost estimation