Re: clearing the buffer cache

From: Chris Mayfield <cmayfiel(at)cs(dot)purdue(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: clearing the buffer cache
Date: 2009-02-16 16:09:59
Message-ID: gnc34m$1eku$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> With recent versions of Linux you can flush the system's buffer cache by
> doing:
>
> # echo 3 > /proc/sys/vm/drop_caches

You can also try something like this:
http://wiki.services.openoffice.org/wiki/Cold-start-simulator

Shutting down the server and running fillmem has worked for me, but that
might take too long in your situation of thousands of small queries. But
I guess "SELECT * FROM large_table" would have taken just as long anyway.

--Chris

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-02-16 16:52:12 Re: ask: select right(column) ???
Previous Message Scara Maccai 2009-02-16 16:08:42 Re: left outer join without rows from "left" table