Re: Using ALTER TABLESPACE in pg_dump

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, Philip Warner <pjw(at)rhyme(dot)com(dot)au>, Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Using ALTER TABLESPACE in pg_dump
Date: 2004-11-01 02:23:55
Message-ID: 200411010223.iA12NtJ17188@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


OK, TODO updated:

* Add a GUC variable to control the tablespace for temporary
objects

---------------------------------------------------------------------------

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Gavin Sherry wrote:
> >> I'm not sure about TOAST however. I considered the idea of adding
> >> something to CREATE TABLE like TOASTSPACE <tablespace>, such that all
> >> TOAST tables would be put in the 'toastspace'. But I think the syntax is
> >> ugly and would confuse many users who do not know what toast is.
>
> > I think we need to add temp_tablespace and toast_tablespace GUC
> > variables to deal with this, perhaps for 8.1.
>
> A tablespace for temp tables is okay, but I'm fairly dubious about the
> idea of a "toast tablespace". The current behavior is that a toast
> table is automatically placed into the same tablespace as its parent,
> and that seems exactly right to me. It's certainly the right thing from
> the point of view of users who do not understand TOAST and expect all of
> a table's data to get put where they said to put the table.
>
> regards, tom lane
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-11-01 02:34:47 Re: [pgsql-hackers-win32] Win32 lost signals open item
Previous Message Tom Lane 2004-11-01 02:18:13 Re: Using ALTER TABLESPACE in pg_dump