| From: | "Erikjan Rijkers" <er(at)xs4all(dot)nl> |
|---|---|
| To: | "Alexander Korotkov" <aekorotkov(at)gmail(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Heikki Linnakangas" <hlinnakangas(at)vmware(dot)com>, "Tomas Vondra" <tv(at)fuzzy(dot)cz>, "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>, Pavel Stìhule <pavel(dot)stehule(at)gmail(dot)com> |
| Subject: | Re: WIP: index support for regexp search |
| Date: | 2013-04-02 20:36:22 |
| Message-ID: | b1711972ccf9c13d4c5a5c64e729cc92.squirrel@webmail.xs4all.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, April 1, 2013 23:15, Alexander Korotkov wrote:
[trgm-regexp-0.14.patch.gz]
Hi Alexander,
Something went wrong in this version of the patch: many (most) queries that were earlier
spectacularly fast have become slow, often slower than a seqscan or only marginally faster. See
the attached numbers; it compares head(seqscan) with trgm-regex patch versions 13 and 14.
I did not even complete the test-run because version 14 is so clearly inferior to 13 (and earlier,
as far as I can remember).
(let me know if you want the whole result, I can run it overnight)
Thanks,
Erik Rijkers
| Attachment | Content-Type | Size |
|---|---|---|
| re-head-13-14-20130402-2219.txt.bz2 | application/x-bzip2 | 10.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2013-04-02 20:53:05 | Re: Proposal for Allow postgresql.conf values to be changed via SQL [review] |
| Previous Message | David Gould | 2013-04-02 19:58:23 | Re: Spin Lock sleep resolution |