Re: [HACKERS] hstore - Implementation and performance issues around its operators

2011-06-21 Thread Alexander Korotkov
Hi! On Tue, Jun 21, 2011 at 12:04 PM, Stefan Keller wrote: > 1. Obviously the '@>' has to be used in order to let use the GiST index. > Why is the '->' operator not supported by GiST ('->' is actually > mentioned in all examples of the doc.)? > I believe it's an architecture problem. You actual

[HACKERS] hstore - Implementation and performance issues around its operators

2011-06-21 Thread Stefan Keller
Hi, We did a benchmark comparing a Key-Value-Pairs stored as EAV db schema versus hstore. The results are promising in favor of hstore but there are some question which remain. 1. Obviously the '@>' has to be used in order to let use the GiST index. Why is the '->' operator not supported by GiST