Horton

Re: WIP: index support for regexp search

Erik Rijkers <er@xs4all.nl>

View thread
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-03T07:10:08Z
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 →

  1. Fix filling of postmaster.pid in bootstrap/standalone mode.

  2. Add explicit casts in ilist.h's inline functions.

Attachments

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