Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 0948B9FA607 for ; Fri, 26 Oct 2007 18:14:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 44806-06 for ; Fri, 26 Oct 2007 18:14:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from serv01.siteground137.com (ns1.siteground137.com [67.15.250.10]) by postgresql.org (Postfix) with ESMTP id 788D39F9C32 for ; Fri, 26 Oct 2007 18:14:12 -0300 (ADT) Received: from cragnux.laika.com ([209.162.219.253]:51523 helo=dogma.ljc.laika.com) by serv01.siteground137.com with esmtpa (Exim 4.68) (envelope-from ) id 1IlWVM-0002g4-Jk; Fri, 26 Oct 2007 16:14:08 -0500 Subject: Re: Tsearch docs question From: Jeff Davis To: Tom Lane Cc: pgsql-docs@postgresql.org In-Reply-To: <24984.1193426786@sss.pgh.pa.us> References: <1193423136.7624.56.camel@dogma.ljc.laika.com> <24984.1193426786@sss.pgh.pa.us> Content-Type: text/plain Date: Fri, 26 Oct 2007 14:14:08 -0700 Message-Id: <1193433248.7624.88.camel@dogma.ljc.laika.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-7) Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - serv01.siteground137.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - j-davis.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/104 X-Sequence-Number: 4525 On Fri, 2007-10-26 at 15:26 -0400, Tom Lane wrote: > Are you looking at CVS HEAD, or what was there in beta1? I rewrote > that stuff a few days ago: > http://developer.postgresql.org/pgdocs/postgres/textsearch-indexes.html > Excellent, thanks, that's a big improvement to those docs all around. I should have checked the latest before posting, almost everything I mentioned was already addressed. There's still one very minor thing: "A GiST index is lossy, meaning it is necessary to check the actual table row to eliminate false matches." could be changed to something like: "A GiST index is lossy, meaning that the index may produce false matches, and it is necessary to check the actual table row before eliminating these false matches. And perhaps change: "Lossiness causes performance degradation since random access to table records is slow; ..." to something like: "Lossiness causes performance degradation due to unnecessary random accesses to table records; ..." The only reason I say this is because, on my first reading, I read that to mean that lossless indexes don't require trips to the heap at all (which isn't true, yet). Regards, Jeff Davis