Re: WIP: index support for regexp search - Mailing list pgsql-hackers

From Erikjan Rijkers
Subject Re: WIP: index support for regexp search
Date
Msg-id b1711972ccf9c13d4c5a5c64e729cc92.squirrel@webmail.xs4all.nl
Whole thread Raw
In response to Re: WIP: index support for regexp search  (Alexander Korotkov <aekorotkov@gmail.com>)
Responses Re: WIP: index support for regexp search
List 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

pgsql-hackers by date:

Previous
From: David Gould
Date:
Subject: Re: Spin Lock sleep resolution
Next
From: Greg Smith
Date:
Subject: Re: Proposal for Allow postgresql.conf values to be changed via SQL [review]