Date: Mon, 30 Mar 1998 13:56:24 -0500 (EST) From: John Fieber <jfieber@indiana.edu> To: Simon Shapiro <shimon@simon-shapiro.org> Cc: freebsd-database@FreeBSD.ORG Subject: RE: Mailing list search interface Message-ID: <Pine.BSF.3.96.980330134953.7795A-100000@fallout.campusview.indiana.edu> In-Reply-To: <XFMail.980330102629.shimon@simon-shapiro.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, 30 Mar 1998, Simon Shapiro wrote: > Truth must be told, currently PostgreSQL uses Unix files to store its > indices and tables, so performance is not all that it could be. I am A properly constructed index for a full text database (read: NOT glimpse) requires very little disk i/o for most queries. Eg, prefix trie hashing requires about two reads per search term in the query. I just read a paper describing some optimtzaion that reduces that to one read about 50% of the time. -john To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.96.980330134953.7795A-100000>