Re: Spliting a table/databases between several disks ?

From: Bo Lorentsen <bl(at)tod(dot)dk>
To: Feite Brekeveld <feite(dot)brekeveld(at)osiris-it(dot)nl>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Spliting a table/databases between several disks ?
Date: 2001-05-23 15:57:54
Message-ID: 3B0BDE02.1AB63CF5@tod.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Feite Brekeveld wrote:

> If you have databases that large that they don't fit on a single disk
> (nowdays 75 Gb !) you definitely should consider to look for a RAID level 5
> solution. For instance using 7 disks of which 2 hot-spares. With the 75 G
> disks you would get to about 350 G diskspace which is logically seen as one
> partition.

It was not alone a question of size, but also a question about performance. If
I could split up my database on table level, I could ballance the performace
between offen used tabels.

Ok, it would also be nice to be able to have somehow large tables, and even
swap these in and out too (for backup). But I think this is a little to much
to ask for :-)

But thanks anyway, I am looking at software RAID anyway, so I'll just continue
in this track.

/BL

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-05-23 16:02:11 Re: Install with Apache/PHP (Was "Stubborn Multibyte")
Previous Message George Herson 2001-05-23 15:55:09 Re: incomplete transaction keeps table locked?