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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-hackers-win32 by date

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