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

From Bruce Momjian
Subject Re: tablespace and sequences?
Date
Msg-id 200408171535.i7HFZ2812915@candle.pha.pa.us
Whole thread Raw
In response to Re: tablespace and sequences?  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers
Fabien COELHO wrote:
> 
> Dear Bruce,
> 
> > > (1) the "CREATE SEQUENCE foo TABLESPACE disk2" syntax does not seem
> > >     to be implemented.
> > >
> > > (2) when creating an implicit sequence with SERIAL, the sequence
> > >     is created in the tablespace of the schema/database, not the one
> > >     of the table, although indexes are added to the tablespace
> > >     of the table. It would seem more logical to put it in
> > >     the same table space as the table by default?
> >
> > We decided it didn't make much sense to allow the on-row sequences to be
> > anywhere but the default tablespace.
> 
> Hmmm...
> 
> I can understand the performance/utility rationale, but I don't like the
> lack of orthogonality on principle. I like elegance;-) As a sequence looks
> a lot like a table, I guess it should not be that hard to have it anyway.
> 
> Well, just my little opinion, and not a big issue.

I can't remember why we didn't just make it orthoginal.

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


pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: tablespace and sequences?
Next
From: Fabien COELHO
Date:
Subject: Re: tablespace and sequences?