Re: GIN fast insert - Mailing list pgsql-hackers

From Robert Haas
Subject Re: GIN fast insert
Date
Msg-id 603c8f070902130602o7cbceaaew4d7cf4d4604ba80d@mail.gmail.com
Whole thread Raw
In response to Re: GIN fast insert  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-hackers
On Fri, Feb 13, 2009 at 8:00 AM, Teodor Sigaev <teodor@sigaev.ru> wrote:
>> SELECT * FROM foo WHERE t @@ query LIMIT 100
>> might be a fairly common use case.
>
> It seems to me -
> SELECT * FROM foo WHERE t @@ query *ORDER BY rank* LIMIT 100;

I'm not sure you can really assume that the ORDER BY rank will always
be in there.

...Robert


pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: [PERFORM] GIST versus GIN indexes for intarrays
Next
From: Kenneth Marshall
Date:
Subject: Re: [PERFORM] GIST versus GIN indexes for intarrays