Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 8E1F02E0037 for ; Tue, 17 Jun 2008 13:04:19 -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 68870-06 for ; Tue, 17 Jun 2008 13:04:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ppsw-5.csi.cam.ac.uk (ppsw-5.csi.cam.ac.uk [131.111.8.135]) by developer.postgresql.org (Postfix) with ESMTP id 2D0CA2E002E for ; Tue, 17 Jun 2008 13:04:16 -0300 (ADT) X-Cam-SpamDetails: Not scanned X-Cam-AntiVirus: No virus found X-Cam-ScannerInfo: http://www.cam.ac.uk/cs/email/scanner/ Received: from flymine.sysbiol.cam.ac.uk ([131.111.60.120]:50437 helo=flymine.flymine.org) by ppsw-5.csi.cam.ac.uk (ppsw.cam.ac.uk [131.111.8.135]:25) with esmtp id 1K8dfD-0005vF-JF (Exim 4.67) for pgsql-performance@postgresql.org (return-path ); Tue, 17 Jun 2008 17:04:07 +0100 Received: from host103 ([192.168.128.103] helo=aragorn.flymine.org ident=Debian-exim) by flymine.flymine.org with esmtp (Exim 4.12) id 1K8dfD-0005l2-00 for pgsql-performance@postgresql.org; Tue, 17 Jun 2008 17:04:07 +0100 Received: from mnw21 (helo=localhost) by aragorn.flymine.org with local-esmtp (Exim 4.69) (envelope-from ) id 1K8dfD-0000Vj-Tq for pgsql-performance@postgresql.org; Tue, 17 Jun 2008 17:04:07 +0100 Date: Tue, 17 Jun 2008 17:04:07 +0100 (BST) From: Matthew Wakeling X-X-Sender: mnw21@aragorn.flymine.org To: pgsql-performance@postgresql.org Subject: Re: Tsearch2 Initial Search Speed In-Reply-To: <200806170856.33022@hal.medialogik.com> Message-ID: References: <4856A91F.1020001@selestial.com> <48579EB1.8050403@selestial.com> <200806170856.33022@hal.medialogik.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/81 X-Sequence-Number: 30431 On Tue, 17 Jun 2008, Alan Hodgson wrote: > 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. Not true - on recent Linux kernels, you can drop the OS cache by running echo "1" >/proc/sys/vm/drop_caches as root. You'll still need to restart Postgres to drop its cache too. Matthew -- Richards' Laws of Data Security: 1. Don't buy a computer. 2. If you must buy a computer, don't turn it on.