Re: Rapid Seek Devices (feature request) - Mailing list pgsql-general

From Jeremy Harris
Subject Re: Rapid Seek Devices (feature request)
Date
Msg-id 4A89A5F9.6070504@wizmail.org
Whole thread Raw
In response to Re: Rapid Seek Devices (feature request)  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: Rapid Seek Devices (feature request)  (NTPT <ntpt@centrum.cz>)
Re: Rapid Seek Devices (feature request)  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
On 08/17/2009 03:24 AM, Craig Ringer wrote:
> On 16/08/2009 9:06 PM, NTPT wrote:
>> So I suggest we should have "random_page_cost" and
>> "Sequential_page_cost" configurable on per tablespace basis.
>
> That strikes me as a REALLY good idea, personally, though I don't know
> enough about the planner to factor in implementation practicalities and
> any cost for people _not_ using the feature.

Could not pgsql *measure* these costs (on a sampling basis, and with long
time-constants)?

- Jeremy

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: attempted to delete invisible tuple
Next
From: Bob Gobeille
Date:
Subject: Re: psql command line editor