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

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 (view raw or flat)
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

pgsql-admin by date

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

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