Postgres Pro
Downloads
Home   >   mailing lists

Re: Values larger than 1/3 of a buffer page cannot be indexed (hstore) - Mailing list pgsql-general

From Tom Lane
Subject Re: Values larger than 1/3 of a buffer page cannot be indexed (hstore)
Date
Msg-id 8613.1304220331@sss.pgh.pa.us
Whole thread Raw
In response to Values larger than 1/3 of a buffer page cannot be indexed (hstore)  (Stefan Keller <sfkeller@gmail.com>)
Responses Re: Values larger than 1/3 of a buffer page cannot be indexed (hstore)  (Stefan Keller <sfkeller@gmail.com>)
List pgsql-general
Tree view 
Stefan Keller <sfkeller@gmail.com> writes:
> Any ideas on how to index my hstore attribute?

Use a GIST or GIN index.  The only thing that a btree index on hstore
can do for you is to support equality comparisons on the whole hstore
value, which is pretty unlikely to be what you're after.

            regards, tom lane

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: histogram
Next
From: Mark Morgan Lloyd
Date:
Subject: Postgresql, PSN hack and table limits