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: (view raw or whole 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?

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.


>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 

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?

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-2015 The PostgreSQL Global Development Group