On Sat, 2002-11-30 at 05:55, Alvaro Herrera wrote:
> On Fri, Nov 29, 2002 at 10:51:26AM -0800, Christopher Kings-Lynne wrote:
>
> > Just out of interest, if someone was going to pay you to hack on Postgres
> > for 6 months, what would you like to code for 7.4?
>
> Well, nobody is paying me, but I want to
>
> - fix the btree problem leaking unused pages (I think I'm getting near,
> I just haven't had free time during the last month). This one is a
> must to me.
>
> - try different regexp algorithms, compare efficiency. Both Henry
> Spencer's new code for Tcl, and Baeza-Navarro shift-or approach (can
> be much faster than "traditional" regex engines)
Perhaps bigger effect could be possible if we could could make
LIKE/REGEXP use indexes - perhaps some approach based on trigrams could
be usable here ?
> (do people care for allowing "search with errors", similar to what
> agrep and nrgrep do?)
Yes, especially if integrated with some full text index scheme.
--
Hannu Krosing <hannu@tm.ee>
