Re: 7.2.1 optimises very badly against 7.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.2.1 optimises very badly against 7.2
Date
Msg-id 15027.1026737252@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7.2.1 optimises very badly against 7.2  (Curt Sampson <cjs@cynic.net>)
List pgsql-general
Curt Sampson <cjs@cynic.net> writes:
> Well, should it then worry about read-ahead? On most OSes, it
> doesn't actually degenerate to 1-block random reads; it degerates
> to something along the lines of 8-block random reads.

Exactly.  There is still an OS-provided benefit for sequential reading,
even if it's not as large as it might be in the absence of any other
activity.  What this line of argument suggests is that random_page_cost
should be reduced in a heavily-loaded system ... but probably not to 1.0.

            regards, tom lane

pgsql-general by date:

Previous
From: Jie Liang
Date:
Subject: Re: [SQL] Please, HELP! Why is the query plan so wrong???
Next
From: Phil Dobbin
Date:
Subject: Re: OSX Install Instructions