Tablespace for temporary objects and sort files

From: Albert Cervera Areny <albertca(at)hotpop(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Tablespace for temporary objects and sort files
Date: 2006-10-24 22:45:48
Message-ID: 200610250045.48361.albertca@hotpop.com
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-patches

Hi,

I'm trying to introduce myself into postgresql development and I'm working on
the "tablespace for temporary objects and sort files" TODO item. The attached
patch shows what I've already done. The GUC is currently
called "temp_tablespaces".

The tablespace changes correctly for me when creating temporary tables. I've
got some questions though:

How can I test that the tablespace is correctly used for sort files? Is there
an easy way? Or should I reduce work_mem to a minimum, populate the database
with data and try an "ORDER BY"?

The GetTempTablespace function correctly returns a different tablespace each
time is called, but I store the position of the last tablespace used with an
integer and iterate through the list of tablespaces each time. I tried to
keep the iterator from call to call but I got a segfault, I imagine due to
the memory context. Should I try to keep the iterator? How can I do it?

Hope the diff and idents are ok. Please let me know if there's something wrong
with them.

Thanks!

Attachment Content-Type Size
temp_tablespaces.diff text/x-diff 6.9 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Toru SHIMOGAKI 2006-10-25 00:28:57 Re: BUG #2704: pg_class.relchecks overflow problem
Previous Message Thomas H. 2006-10-24 15:30:15 Re: could not rename xlog (was: BUG #2712)