Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id BA63D2E003C for ; Tue, 17 Jun 2008 12:55:31 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 56868-05 for ; Tue, 17 Jun 2008 12:55:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from skynet.simkin.ca (skynet.simkin.ca [72.51.27.117]) by developer.postgresql.org (Postfix) with ESMTP id 729D22E002E for ; Tue, 17 Jun 2008 12:55:28 -0300 (ADT) Received: from charon.medialogik.com (S0106000c6eb33e73.vc.shawcable.net [70.79.155.38]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by skynet.simkin.ca (Postfix) with ESMTP id 5DC254A29 for ; Tue, 17 Jun 2008 08:55:26 -0700 (PDT) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-performance@postgresql.org Subject: Re: Tsearch2 Initial Search Speed Date: Tue, 17 Jun 2008 08:55:21 -0700 User-Agent: KMail/1.9.6 (enterprise 0.20070907.709405) References: <4856A91F.1020001@selestial.com> <485789C1.3000803@selestial.com> <485797D4.7010201@selestial.com> In-Reply-To: <485797D4.7010201@selestial.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200806170855.21575@hal.medialogik.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/79 X-Sequence-Number: 30429 On Tuesday 17 June 2008, Howard Cole wrote: > This misses out the random access of the email table, turning my 27 > second query into 6 seconds. It took less time because it retrieved a lot less data - it still has to look at the table. -- Alan