Postgres Pro
Downloads
Home   >   mailing lists

Re: Tsearch2 Initial Search Speed - Mailing list pgsql-performance

From Alan Hodgson
Subject Re: Tsearch2 Initial Search Speed
Date
Msg-id 200806170856.33022@hal.medialogik.com
Whole thread Raw
In response to Re: Tsearch2 Initial Search Speed  (Howard Cole <howardnews@selestial.com>)
Responses Re: Tsearch2 Initial Search Speed  (Matthew Wakeling <matthew@flymine.org>)
List pgsql-performance
Tree view 
On Tuesday 17 June 2008, Howard Cole <howardnews@selestial.com> 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

pgsql-performance by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Tsearch2 Initial Search Speed
Next
From: Matthew Wakeling
Date:
Subject: Re: Tsearch2 Initial Search Speed