Skip site navigation (1) Skip section navigation (2)

Re: Tablespaces

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Tablespaces
Date: 2004-02-26 12:12:41
Message-ID: Pine.LNX.4.44.0402261306110.10106-100000@zigo.dhs.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-win32
On Thu, 26 Feb 2004, Gavin Sherry wrote:

> Comments? Questions? Suggestions?

Is that plan that in the future one can split a single table into 
different table spaces? Like storing all rows with year < 1999 in one 
tablespace and the rest in another?

With the rule system and two underlying tables one could make it work by 
hand I think.

I've never used tablespaces in oracle so I don't know what it can offer. I 
though it could do things like the above. True? What is the syntax and 
for example, how does it effect indexes (not at all maybe).

If you don't want to discuss this now, I understand. It's not part of the
design as it is now. I'm just curious at what direction we are moving and
what is possible to do.

-- 
/Dennis Björklund


In response to

Responses

pgsql-hackers by date

Next:From: Gavin SherryDate: 2004-02-26 12:22:28
Subject: Re: Tablespaces
Previous:From: Gavin SherryDate: 2004-02-26 11:58:25
Subject: Re: Tablespaces

pgsql-hackers-win32 by date

Next:From: Gavin SherryDate: 2004-02-26 12:22:28
Subject: Re: Tablespaces
Previous:From: Gavin SherryDate: 2004-02-26 11:58:25
Subject: Re: Tablespaces

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group