Re: Hstore: Query speedups with Gin index

From: Blake Smith <blakesmith0(at)gmail(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Hstore: Query speedups with Gin index
Date: 2013-09-05 18:42:56
Message-ID: CAPxT4eEYDTz2sY+tEwf+nZrp=Z5zxaWgq+Bm_WUhfi7Qf+LkDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Peter,

Thanks for checking the tests. I wasn't able to duplicate your test
results. Did you run the hstore regression tests with the revised patch I
attached in the thread? Attached is the output I got with the latest patch
applied.

Thanks!

Blake

On Tue, Sep 3, 2013 at 8:04 PM, Peter Eisentraut <peter_e(at)gmx(dot)net> 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 the on-disk incompatibility. I've
> > submitted the patch to commitfest
> > here: https://commitfest.postgresql.org/action/patch_view?id=1203
>
> I'm getting the attached failure from the hstore regression test.
>
>
>
>

--
Blake Smith
http://blakesmith.me
@blakesmith

Attachment Content-Type Size
regressions.diff application/octet-stream 1.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2013-09-05 18:56:08 Re: [HACKERS] Is it necessary to rewrite table while increasing the scale of datatype numeric？
Previous Message Peter Geoghegan 2013-09-05 18:42:25 Re: lcr v5 - introduction of InvalidCommandId