Re: Tablespace and cpu costs - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Tablespace and cpu costs
Date
Msg-id 41240507.5070909@familyhealth.com.au
Whole thread Raw
In response to Re: Tablespace and cpu costs  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-hackers
> The first is to add a parameter to CREATE TABLESPACE and ALTER TABLESPACE
> called RANDOMPAGECOST (or something like that) which allows users to set
> the random page cost for a given tablespace. I'm undecided as to whether
> they should be able to set the sequential scan cost. That seems
> reasonable too at first look.
> 
> The second option is to have a pg_tablespace.conf file which defines
> tablespace specific settings in some way or another.
> 
> Either way, the data will be feed into the planner so that the costing
> routines will be able to use them.
> 
> Anyone else got some thoughts on how we could do this in a cleaner manner?

Yes, exactly like we have ALTER USER SET blah=foo; and ALTER DATABASE 
SET blah = foo;

Chris



pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: PGPASSWORD and client tools
Next
From: Bruce Momjian
Date:
Subject: Re: tablespace and sequences?