Re: How is random_page_cost=4 ok? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: How is random_page_cost=4 ok?
Date
Msg-id 200810150038.m9F0clb07585@momjian.us
Whole thread Raw
In response to Re: How is random_page_cost=4 ok?  ("Nikolas Everett" <nik9000@gmail.com>)
List pgsql-hackers
Nikolas Everett wrote:
> >
> > In any case your experience doesn't match mine. On a machine with a sizable
> > raid controller setting random_page_cost higher does generate, as expected,
> > plans with more bitmap heap scans which are in fact faster.
> >
> 
> We're running postgres backed by a NetApp 3020 via fiber and have had a lot
> of success setting random page cost very high (10).  Sequential reads are
> just that much faster.  I'm not sure if thats because we've configured
> something wrong or what, but thats a really useful knob for us.

One other issue is that sequential I/O for data that is mostly random is
going to wipe more of the buffer cache than random access, so there
should perhaps be some additional cost associated with sequential access
to bias toward random access.  Not sure how our new code that prevents
large table scans from wiping the cache affect this.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: minimal update
Next
From: "Hitoshi Harada"
Date:
Subject: Re: Window Functions