multiple hard disk

Started by Luis Alberto Amigo Navarroover 24 years ago3 messagesgeneral
Jump to latest
#1Luis Alberto Amigo Navarro
lamigo@atc.unican.es

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

#2Bryan White
bryan@arcamax.com
In reply to: Luis Alberto Amigo Navarro (#1)
Re: multiple hard disk

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.

#3Francisco Reyes
lists@natserv.com
In reply to: Bryan White (#2)
Re: multiple hard disk

On Wed, 14 Nov 2001, Bryan White wrote:

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.

How can one tell the location of a table/index?
In my "data/base" directory all I see is directories with numerical names.
Inside of of those directories there are files, also with numerical names.
The only two files which are not numbers are PG_VERSION and
pg_internatl.init.