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 <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html