Postgres Pro
Downloads
Home   >   mailing lists

Re: Regression - Query requires full scan, GIN doesn't support it - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: Regression - Query requires full scan, GIN doesn't support it
Date
Msg-id 467B93FD.9060508@sigaev.ru
Whole thread Raw
In response to Regression - Query requires full scan, GIN doesn't support it  (Stuart Bishop <stuart@stuartbishop.net>)
List pgsql-general
Tree view 
> Is this a permanent limitation of GIN, or is a fix possible?
Permanent. You could check user input by querytree() function --- if it returns
'T' string then fullscan will be needed. If your tsquery is produced by
plainto_tsquery() call then it will not find any result, so you can show to user
void page.

> Is a fix being worked on?
> If a fix is forthcoming, will it be available in the 8.2 series or only 8.3+?

Possibly, full fix in 8.4. But I will not promise.
8.3 will have protection from queries which doesn't match anything.

--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Can I backup/restore a database in a sql script?
Next
From: David Goodenough
Date:
Subject: Re: Regular express question