Thread: Tablespaces for temporary objects

Tablespaces for temporary objects

From
Albert Cervera Areny
Date:
Hi,       I've decided to start hacking on PostgreSQL, and I've looked at the 
easier jobs in the TODO list. I'm interested in implementing:

% Add a GUC variable to control the tablespace for temporary objects and sort 
files. It could start with a random tablespace from a supplied list and cycle 
through the list.
       I wanted to know if there are any comments on how I should implement 
this. I've already started and temporary tables already honour 
the 'temp_tablespaces' GUC variable I created. However, I'm not very happy 
with the name, and probably someone will have other comments on this.
       Thanks.



Re: Tablespaces for temporary objects

From
"Jim C. Nasby"
Date:
On Tue, Sep 19, 2006 at 01:10:48AM +0200, Albert Cervera Areny wrote:
> Hi,
>         I've decided to start hacking on PostgreSQL, and I've looked at the 
> easier jobs in the TODO list. I'm interested in implementing:
> 
> % Add a GUC variable to control the tablespace for temporary objects and sort 
> files. It could start with a random tablespace from a supplied list and cycle 
> through the list.
> 
>         I wanted to know if there are any comments on how I should implement 
> this. I've already started and temporary tables already honour 
> the 'temp_tablespaces' GUC variable I created. However, I'm not very happy 
> with the name, and probably someone will have other comments on this.

If you've already got a patch for this, you should submit it to
pgsql-patches and request feedback there.
-- 
Jim Nasby                                    jimn@enterprisedb.com
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)