"Craig A. James" <cjames(at)modgraph-usa(dot)com> writes:
> Steve Atkins wrote:
>> As long as you're ordering by some row in the table then you can do that in
>> straight SQL.
>> select a, b, ts from foo where (stuff) and foo > X order by foo limit 10
>> Then, record the last value of foo you read, and plug it in as X the next
>> time around.
> We've been over this before in this forum: It doesn't work as advertised. Look for postings by me regarding the fact that there is no way to tell the optimizer the cost of executing a function. There's one, for example, on Oct 18, 2006.
? I don't see anything there that bears on Steve's suggestion.
(The complaint is obsolete as of CVS HEAD anyway.)
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Michael Stone||Date: 2007-03-22 18:46:15|
|Subject: Re: Parallel Vacuum|
|Previous:||From: Steve Atkins||Date: 2007-03-22 18:37:19|
|Subject: Re: Performance of count(*)|