| From: | Alexander Korotkov <aekorotkov(at)gmail(dot)com> |
|---|---|
| To: | Rod Taylor <rbt(at)simple-knowledge(dot)com> |
| Cc: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: GIN improvements part2: fast scan |
| Date: | 2013-11-15 06:51:00 |
| Message-ID: | CAPpHfdt2uGgD1r+xnHO6SqN=ShgJeJqvWcjnVa2PU2ApP4H=hg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Nov 15, 2013 at 3:25 AM, Rod Taylor <rbt(at)simple-knowledge(dot)com>wrote:
> I checked out master and put together a test case using a small percentage
> of production data for a known problem we have with Pg 9.2 and text search
> scans.
>
> A small percentage in this case means 10 million records randomly
> selected; has a few billion records.
>
>
> Tests ran for master successfully and I recorded timings.
>
>
>
> Applied the patch included here to master along with
> gin-packed-postinglists-14.patch.
> Run make clean; ./configure; make; make install.
> make check (All 141 tests passed.)
>
> initdb, import dump
>
>
> The GIN index fails to build with a segfault.
>
Thanks for testing. See fixed version in thread about packed posting lists.
------
With best regards,
Alexander Korotkov.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2013-11-15 06:54:25 | Re: Improve code in tidbitmap.c |
| Previous Message | Alexander Korotkov | 2013-11-15 06:49:37 | Re: GIN improvements part 1: additional information |