| From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
|---|---|
| To: | Stuart Bishop <stuart(at)stuartbishop(dot)net> |
| Cc: | PgSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Regression - Query requires full scan, GIN doesn't support it |
| Date: | 2007-06-22 09:18:53 |
| Message-ID: | 467B93FD.9060508@sigaev.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Goodenough | 2007-06-22 09:25:52 | Re: Regular express question |
| Previous Message | Richard Huxton | 2007-06-22 09:09:39 | Re: [GENERAL] Can I backup/restore a database in a sql script? |