Hi Andreas,
On 27/09/2013 09:24, Andreas Kretschmer wrote:
> This query can't use the index:
>
> test=*# explain select * from my_hstore where werte->'key1' = 'val1';
> QUERY PLAN
> ------------------------------------------------------------------------------
> Seq Scan on my_hstore (cost=10000000000.00..10000000001.06 rows=1 width=36)
> Filter: ((werte -> 'key1'::text) = 'val1'::text)
> (2 rows)
According to the docs:
hstore has GiST and GIN index support for the @>, ?, ?& and ?| operators
http://www.postgresql.org/docs/9.3/static/hstore.html
Cheers
--
Matteo Beccati
Development & Consulting - http://www.beccati.com/