Re: LIMIT Optimization - Mailing list pgsql-sql

From Tom Lane
Subject Re: LIMIT Optimization
Date
Msg-id 26850.1011981496@sss.pgh.pa.us
Whole thread Raw
In response to LIMIT Optimization  ("alexandre paes :: aldeia digital" <alepaes@aldeiadigital.com.br>)
List pgsql-sql
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> So, it is only valuable for cursors

Right; I can see no rhyme or reason for attaching it to a plain SELECT,
unless the system provides some way of stopping short of fetching all of
a SELECT, which we don't.  A CURSOR would be the analogous thing in PG.
        regards, tom lane


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: LIMIT Optimization
Next
From: Oleg Bartunov
Date:
Subject: Re: Arrays Question