Re: WIP: index support for regexp search

Erik Rijkers <er@xs4all.nl>

From: "Erikjan Rijkers" <er@xs4all.nl>

To: "Alexander Korotkov" <aekorotkov@gmail.com>

Cc: "Tom Lane" <tgl@sss.pgh.pa.us>, "Heikki Linnakangas" <hlinnakangas@vmware.com>, "Tomas Vondra" <tv@fuzzy.cz>, "pgsql-hackers" <pgsql-hackers@postgresql.org>, Pavel Stìhule <pavel.stehule@gmail.com>

Date: 2013-04-02T20:36:22Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix filling of postmaster.pid in bootstrap/standalone mode.
- c29947722955 9.3.0 cited
Add explicit casts in ilist.h's inline functions.
- e78d288c895b 9.3.0 cited

Attachments

re-head-13-14-20130402-2219.txt.bz2 (application/x-bzip2)

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