Re: using multiple partitions for a single table - Mailing list pgsql-admin

From Chad R. Larson
Subject Re: using multiple partitions for a single table
Date
Msg-id 4.2.2.20010905191614.00c06758@ecint.ecinet.com
Whole thread Raw
In response to Re: using multiple partitions for a single table  (David Stanaway <david@netventures.com.au>)
List 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@stanaway.net
>Work: david@netventures.com.au
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://www.postgresql.org/search.mpl

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


pgsql-admin by date:

Previous
From: ecaillava@interlap.com.ar
Date:
Subject: Re: postgresql and samba II (or III?)
Next
From: Tom Lane
Date:
Subject: Re: using multiple partitions for a single table