Re: Values larger than 1/3 of a buffer page cannot be indexed (hstore)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stefan Keller <sfkeller(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Values larger than 1/3 of a buffer page cannot be indexed (hstore)
Date: 2011-05-01 03:25:31
Message-ID: 8613.1304220331@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stefan Keller <sfkeller(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Morgan Lloyd 2011-05-01 05:50:50 Postgresql, PSN hack and table limits
Previous Message Rob Sargent 2011-04-30 23:35:43 Re: histogram