Re: slow IN() clause for many cases

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, andrew(at)supernews(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: slow IN() clause for many cases
Date: 2005-10-16 21:49:50
Message-ID: 87irvxdtdt.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Martijn van Oosterhout <kleptog(at)svana(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2005-10-16 21:51:04 Re: PostgreSQL roadmap for 8.2 and beyond.
Previous Message mark 2005-10-16 21:44:01 Re: Question about Ctrl-C and less