Horton

Re: WIP: index support for regexp search

Alexander Korotkov <aekorotkov@gmail.com>

View thread
From: Alexander Korotkov <aekorotkov@gmail.com>
To: Erik Rijkers <er@xs4all.nl>
Cc: Heikki Linnakangas <hlinnakangas@vmware.com>, Tom Lane <tgl@sss.pgh.pa.us>, Tomas Vondra <tv@fuzzy.cz>, pgsql-hackers@postgresql.org, pavel.stehule@gmail.com
Date: 2012-12-17T09:16:42Z
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.

Hi!

On Mon, Dec 17, 2012 at 12:54 PM, Erik Rijkers <er@xs4all.nl> wrote:

> On Sun, December 16, 2012 22:25, Alexander Korotkov wrote:
>
> > trgm-regexp-0.8.patch.gz   22 k
>
> Hi Alexander,
>
> I gave this a quick try; the patch works when compiled for DEBUG, but
> crashes as a
> 'speed'-compiled binary:
>
> Compile for speed:
>
> $ pg_config --configure
> '--prefix=/home/aardvark/pg_stuff/pg_installations/pgsql.trgm_regex8'
> '--with-pgport=6556'
> '--enable-depend' '--with-openssl' '--with-perl' '--with-libxml'
>
> $ psql
> psql
> (9.3devel-trgm_regex8-20121216_2336-c299477229559d4ee7db68720d86d3fb391db761)
> Type "help" for help.
>
> testdb=# explain analyze select txt from azjunk5 where txt ~
> 'x[aeiouy]{2,5}q';
> The connection to the server was lost. Attempting reset: Failed.
> !> \q
>

Didn't reproduce it yet. Can you retry it with this line uncommented:
#define TRGM_REGEXP_DEBUG
Then we can see which stage it fails.

------
With best regards,
Alexander Korotkov.