Re: why do optimizer parameters have to be set manually? - Mailing list pgsql-performance

From William Yu
Subject Re: why do optimizer parameters have to be set manually?
Date
Msg-id brvddd$1u7p$1@news.hub.org
Whole thread Raw
In response to Re: why do optimizer parameters have to be set manually?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tom Lane wrote:
> easy or cheap to get a measurement that isn't skewed by kernel caching
> behavior.  (You need a test file significantly larger than RAM, and
> even then you'd better repeat the measurement quite a few times to see
> how much noise there is in it.)

I found a really fast way in Linux to flush the kernel cache and that is
to unmount the drive and then remount. Beats having to read though a
file > RAM everytime.


pgsql-performance by date:

Previous
From: Erki Kaldjärv
Date:
Subject: Re: is it possible to get the optimizer to use indexes
Next
From: Ryszard Lach
Date:
Subject: "select max/count(id)" not using index