Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 717752E0037 for ; Tue, 17 Jun 2008 12:56:41 -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 58446-07 for ; Tue, 17 Jun 2008 12:56:38 -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 8C2612E004D for ; Tue, 17 Jun 2008 12:56:38 -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 772414A55 for ; Tue, 17 Jun 2008 08:56:37 -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:56:32 -0700 User-Agent: KMail/1.9.6 (enterprise 0.20070907.709405) References: <4856A91F.1020001@selestial.com> <48579EB1.8050403@selestial.com> In-Reply-To: <48579EB1.8050403@selestial.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200806170856.33022@hal.medialogik.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/80 X-Sequence-Number: 30430 On Tuesday 17 June 2008, Howard Cole wrote: > Incidentally, how can I clear the cache in between queries? Stop PostgreSQL, unmount the filesystem it's on, remount it, restart PostgreSQL. Works under Linux. If it's on a filesystem you can't unmount hot, you'll need to reboot. -- Alan