Re: multiple hard disk

From: "Bryan White" <bryan(at)arcamax(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: multiple hard disk
Date: 2001-11-14 18:45:15
Message-ID: 015301c16d3c$801bb790$2ed260d1@bryan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Is there any way (excluding RAID) to split a database information
> between multiple hard disks?

I think you can selectively move table/index files to another location and
create symbolic links from the original location. The postmaster must be
stopped while you are doing this.

Keep in mind that Postgres will create separate files for each 1GB of a
table. So if your table grows substantually after you set this up, new
segment files may have been created, thus partially undoing the effect you
were trying to achieve.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thalis A. Kalfigopoulos 2001-11-14 18:47:32 Re: Modifying check constraints
Previous Message Paulo Jan 2001-11-14 18:27:04 Modifying check constraints