Re: tablespace and sequences? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: tablespace and sequences?
Date
Msg-id 20040820033632.GM6173@dcc.uchile.cl
Whole thread Raw
In response to Re: tablespace and sequences?  (Philip Warner <pjw@rhyme.com.au>)
Responses Re: tablespace and sequences?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: tablespace and sequences?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Aug 20, 2004 at 01:26:39PM +1000, Philip Warner wrote:
> At 01:09 PM 20/08/2004, Tom Lane wrote:
> >It seemed like a reasonable idea to me...
> 
> Do we have a "SET DEFAULT TABLESPACE"? Can we add one for this release? If 
> not, we probably need to go with the ALTER TABLE. Although a SET DEFAULT 
> TABLESPACE would be convenent in general.

The problem with ALTER TABLE is that it can be hugely expensive, I think.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Thou shalt check the array bounds of all strings (indeed, all arrays), for
surely where thou typest "foo" someone someday shall type
"supercalifragilisticexpialidocious" (5th Commandment for C programmers)



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgres uptime
Next
From: Bruce Momjian
Date:
Subject: Re: tablespace and sequences?