Re: 7.4 Wishlist

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>