Re: [HACKERS] Hstore: Query speedups with Gin index

2013-09-09 Thread Blake Smith
; On Tue, Sep 3, 2013 at 6:24 PM, Blake Smith wrote: > >> Thanks for the feedback everyone. I've attached the patch that we are now >> running in production to service our hstore include queries. We rebuilt the >> index to account for the on-disk incompatibility

Re: [HACKERS] Hstore: Query speedups with Gin index

2013-09-05 Thread Blake Smith
Peter Eisentraut wrote: > On Tue, 2013-09-03 at 09:24 -0500, Blake Smith wrote: > > Thanks for the feedback everyone. I've attached the patch that we are > > now running in production to service our hstore include queries. We > > rebuilt the index to account for th

Re: [HACKERS] Hstore: Query speedups with Gin index

2013-09-03 Thread Blake Smith
27;s only user testing). Thanks, Blake On Wed, Aug 28, 2013 at 12:40 PM, Andres Freund wrote: > On 2013-08-28 13:31:22 -0400, Bruce Momjian wrote: > > On Sun, Aug 25, 2013 at 10:11:50PM -0400, Tom Lane wrote: > > > Michael Paquier writes: > > > > On Thu, Aug 22,

[HACKERS] Hstore: Query speedups with Gin index

2013-08-22 Thread Blake Smith
Hey everyone, I'm looking for feedback on a contrib/hstore patch. We've been experiencing slow "@>" queries involving an hstore column that's covered by a Gin index. At the current postgresql git HEAD, the hstore <-> gin interface produces the following text items to be indexed: hstore: "'a'=>'1