Re: slow IN() clause for many cases - Mailing list pgsql-hackers

From Greg Stark
Subject Re: slow IN() clause for many cases
Date
Msg-id 87irvxdtdt.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: slow IN() clause for many cases  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: slow IN() clause for many cases
List pgsql-hackers
Martijn van Oosterhout <kleptog@svana.org> writes:

> > (I think there really ought to be a bit in the protocol that the client sends
> > with the query to indicate which is needed. That would be cleaner than
> > Oracle's /*+ FIRST_ROW */ and /*+ ALL_ROWS */ hints.)
> 
> It's called LIMIT and has been supported for a long time.

And if I *don't* want to limit the number of rows I retriev?

-- 
greg



pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: slow IN() clause for many cases
Next
From: Neil Conway
Date:
Subject: Re: PostgreSQL roadmap for 8.2 and beyond.