| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | tomas(at)tuxteam(dot)de |
| Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Darcy Buskermolen <darcyb(at)commandprompt(dot)com>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, PgSQL General <pgsql-general(at)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] Index greater than 8k |
| Date: | 2006-11-01 22:16:37 |
| Message-ID: | 20061101221637.GA12381@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
tomas(at)tuxteam(dot)de wrote:
> On Tue, Oct 31, 2006 at 08:55:04PM -0800, Joshua D. Drake wrote:
> >
> > >> We are not storing bytea [...]
> [...]
> > > Hmm, have you tried to create a functional trigram index on the
> > > equivalent of "strings(bytea_column)" or something like that?
>
> Hrm. Sorry for my impolite interuption, but... is there such a thing as
> a "functional trigram index"? (this would be very cool).
Heh :-) I meant an index, using the pg_trgm opclass (which indexes
trigrams; hence the "trigram" part), on a function that would extract
the text from a bytea column; instead of indexing the trigrams of the
bytea column directly. Hence the "functional" part.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karsten Hilbert | 2006-11-01 22:52:06 | Re: Encoding, Unicode, locales, etc. |
| Previous Message | Thomas Burns | 2006-11-01 21:50:58 | pg_dump question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2006-11-01 23:22:01 | Re: [HACKERS] Index greater than 8k |
| Previous Message | Stephen Frost | 2006-11-01 21:06:34 | Re: IN(subselect returning few values ...) |