| 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-03 07:10:08 |
| Message-ID: | a21ae23463c1e89178169c38e8192d26.squirrel@webmail.xs4all.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, April 2, 2013 23:54, Alexander Korotkov wrote:
> [trgm-regexp-0.15.patch.gz]
Yes, it does look good now; Attached a list of measurements. Most of the searches that I put in
that test-program are now speeded up very much.
There still are a few regressions, for example:
HEAD azjunk6 x[aeiou]{4,5}q 83 Seq Scan 1393.465 ms
trgm_regex15 azjunk6 x[aeiou]{4,5}q 83 Bitmap Heap Scan 1728.319 ms
HEAD azjunk7 x[aeiou]{1,3}q 190031 Seq Scan 16819.555 ms
trgm_regex15 azjunk7 x[aeiou]{1,3}q 190031 Bitmap Heap Scan 21286.804 ms
Not exactly negligible, and ideally those regressions would be removed but with the huge
advantages for other cases I'd say it's worth it.
hth,
Erik Rijkers
| Attachment | Content-Type | Size |
|---|---|---|
| re-head-13-15-20130403-0708.txt.bz2 | application/x-bzip2 | 9.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Korotkov | 2013-04-03 09:18:27 | Re: WIP: index support for regexp search |
| Previous Message | Stefan Kaltenbrunner | 2013-04-03 06:46:27 | Re: spoonbill vs. -HEAD |