Re: strpos() && KMP - Mailing list pgsql-patches

From Pavel Ajtkulov
Subject Re: strpos() && KMP
Date
Msg-id 1985342014.20070808001953@acm.org
Whole thread Raw
In response to Re: strpos() && KMP  (Decibel! <decibel@decibel.org>)
Responses Re: strpos() && KMP  (Decibel! <decibel@decibel.org>)
Re: strpos() && KMP  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
> Do you have any performance test results for this?

I describe the worst case in first message (search 'aaa..aab' in
'aa..aa', "complete" N^2). It works some msec instead of several sec
(in current version).

Patch intends for artificial language (for example DNA, or
language with small alphabet, or regular language) only.

In natural language, KMP(and other search algo) haven't notable
advantages (+-5% time execution).

----
Ajtkulov Pavel
ajtkulov@acm.org



pgsql-patches by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: further WIP for COPYable logs
Next
From: Decibel!
Date:
Subject: Re: strpos() && KMP