Re: using multiple partitions for a single table

From: "Chad R(dot) Larson" <clarso(at)eldocomp(dot)com>
To: David Stanaway <david(at)netventures(dot)com(dot)au>, "Taher H(dot) Haveliwala" <taherh24(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: using multiple partitions for a single table
Date: 2001-09-06 02:19:32
Message-ID: 4.2.2.20010905191614.00c06758@ecint.ecinet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

At 04:55 PM 9/4/2001 , David Stanaway wrote:

>On Wednesday, September 5, 2001, at 06:58 AM, Taher H. Haveliwala wrote:
>
>>Is it possible in postgres 7.1.3 to have a single
>>table span multiple partitions? Or is using RAID the
>>only option?
>>
>>Thanks
>>Taher

Yes, you can move individual files that are under your $PGDATA directory to
some other volumes, and then point to them with symbolic links.

>Hi there,
>On Linux, you can use LVM (Logical Volume Manager) to do what you want.

[snip]

>I believe there is a similar (Even the same..) project for BSD, and of
>course it is inspired by stuff that commercial unix systems have had for a
>while.

It's called "vinum", and is modeled after (or at least inspired by) the
Veritas Volume Manager.

>==============================
>David Stanaway
>Personal: david(at)stanaway(dot)net
>Work: david(at)netventures(dot)com(dot)au
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://www.postgresql.org/search.mpl

-crl
--
Chad R. Larson (CRL22) chad(at)eldocomp(dot)com
Eldorado Computing, Inc. 602-604-3100
5353 North 16th Street, Suite 400
Phoenix, Arizona 85016-3228

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-09-06 02:57:46 Re: using multiple partitions for a single table
Previous Message pmiranda 2001-09-05 21:50:57 pg_dump & Win 9X/NT