Thread: Tablespace and cpu costs

Tablespace and cpu costs

From
Gaetano Mendola
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,
now that we have the tablespace support don't you think that
each tablespace needs his own costs instead of a system wide
one ?

I searched in the archives and on the TODO list without success.

Regards
Gaetano Mendola


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBIz2i7UpzwH2SGd4RAvLqAJ9fKt/1wy8sKySEIptubwz+CR85CACg/q3x
IOPx9xKYld8WJJaDaydQtgE=
=8w+B
-----END PGP SIGNATURE-----



Re: Tablespace and cpu costs

From
Gavin Sherry
Date:
On Wed, 18 Aug 2004, Gaetano Mendola wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi all,
> now that we have the tablespace support don't you think that
> each tablespace needs his own costs instead of a system wide
> one ?
>
> I searched in the archives and on the TODO list without success.

Yep. I've looked at this but didn't think it necessary for the first stage
of implementation.

I definately plan to do it for 8.1

Gavin


Re: Tablespace and cpu costs

From
Gaetano Mendola
Date:
Gavin Sherry wrote:

> On Wed, 18 Aug 2004, Gaetano Mendola wrote:
>>-----BEGIN PGP SIGNED MESSAGE-----
>>Hash: SHA1
>>
>>Hi all,
>>now that we have the tablespace support don't you think that
>>each tablespace needs his own costs instead of a system wide
>>one ?
>>
>>I searched in the archives and on the TODO list without success.
> 
> 
> Yep. I've looked at this but didn't think it necessary for the first stage
> of implementation.
> 
> I definately plan to do it for 8.1

Do you have an Idea on how you want implement this ( usage side ) ?



Regards
Gaetano Mendola




Re: Tablespace and cpu costs

From
Gavin Sherry
Date:
On Wed, 18 Aug 2004, Gaetano Mendola wrote:

> Gavin Sherry wrote:
>
> > On Wed, 18 Aug 2004, Gaetano Mendola wrote:
> >>-----BEGIN PGP SIGNED MESSAGE-----
> >>Hash: SHA1
> >>
> >>Hi all,
> >>now that we have the tablespace support don't you think that
> >>each tablespace needs his own costs instead of a system wide
> >>one ?
> >>
> >>I searched in the archives and on the TODO list without success.
> >
> >
> > Yep. I've looked at this but didn't think it necessary for the first stage
> > of implementation.
> >
> > I definately plan to do it for 8.1
>
> Do you have an Idea on how you want implement this ( usage side ) ?
>

Well, as far as I can tell there are two ways we could do it without
reinventing the wheel -- but both are ugly.

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?

Gavin


Re: Tablespace and cpu costs

From
Christopher Kings-Lynne
Date:
> 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



Re: Tablespace and cpu costs

From
Gaetano Mendola
Date:
Gavin Sherry wrote:

> On Wed, 18 Aug 2004, Gaetano Mendola wrote:
> 
> 
>>Gavin Sherry wrote:
>>
>>
>>>On Wed, 18 Aug 2004, Gaetano Mendola wrote:
>>>
>>>>-----BEGIN PGP SIGNED MESSAGE-----
>>>>Hash: SHA1
>>>>
>>>>Hi all,
>>>>now that we have the tablespace support don't you think that
>>>>each tablespace needs his own costs instead of a system wide
>>>>one ?
>>>>
>>>>I searched in the archives and on the TODO list without success.
>>>
>>>
>>>Yep. I've looked at this but didn't think it necessary for the first stage
>>>of implementation.
>>>
>>>I definately plan to do it for 8.1
>>
>>Do you have an Idea on how you want implement this ( usage side ) ?
>>
> 
> 
> Well, as far as I can tell there are two ways we could do it without
> reinventing the wheel -- but both are ugly.
> 
> 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.

That is the goal.

> Anyone else got some thoughts on how we could do this in a cleaner manner?

I think we need both, I think could be also usefull add a STORE option:

ALTER TABLESPACE RANDOMPAGECOST 0.001 STORE

if the STORE is present then the pg_tablespace.conf is updated

this could be argued with the fact that we do not have SET cpu_costs STORE bu this
doesn't mean that we can not have it in the future :-)

I think is also usefull insert it in the dump "as comment" before the tablespace
creation, this in order to don't loose these setting.


Regards
Gaetano Mendola