Re: why do optimizer parameters have to be set manually?

From: William Yu <wyu(at)talisys(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: why do optimizer parameters have to be set manually?
Date: 2003-12-19 17:44:17
Message-ID: brvddd$1u7p$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ryszard Lach 2003-12-22 10:39:18 "select max/count(id)" not using index
Previous Message Erki Kaldjärv 2003-12-19 16:00:25 Re: is it possible to get the optimizer to use indexes