Skip site navigation (1) Skip section navigation (2)

Re: Tsearch2 Initial Search Speed

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tsearch2 Initial Search Speed
Date: 2008-06-17 15:56:32
Message-ID: 200806170856.33022@hal.medialogik.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Tuesday 17 June 2008, Howard Cole <howardnews(at)selestial(dot)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

In response to

Responses

pgsql-performance by date

Next:From: Matthew WakelingDate: 2008-06-17 16:04:07
Subject: Re: Tsearch2 Initial Search Speed
Previous:From: Alan HodgsonDate: 2008-06-17 15:55:21
Subject: Re: Tsearch2 Initial Search Speed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group