Re: Moving postgresql.conf tunables into 2003... - Mailing list pgsql-performance

From Rod Taylor
Subject Re: Moving postgresql.conf tunables into 2003...
Date
Msg-id 1057263840.31736.22.camel@jester
Whole thread Raw
In response to Moving postgresql.conf tunables into 2003...  (Sean Chittenden <sean@chittenden.org>)
Responses Re: Moving postgresql.conf tunables into 2003...
List pgsql-performance
On Thu, 2003-07-03 at 19:05, Sean Chittenden wrote:
> What are the odds of going through and revamping some of the tunables
> in postgresql.conf for the 7.4 release?  I was just working with
> someone on IRC and on their 7800 RPM IDE drives, their
> random_page_cost was ideally suited to be 0.32: a far cry from 4.

I find it very very hard to believe a random read was cheaper than a
sequential read.  Something is shifty in your testing.

Attachment

pgsql-performance by date:

Previous
From: Sean Chittenden
Date:
Subject: Moving postgresql.conf tunables into 2003...
Next
From: "scott.marlowe"
Date:
Subject: Re: Moving postgresql.conf tunables into 2003...