Re: multiple hard disk
Bryan White <bryan@arcamax.com>
From: "Bryan White" <bryan@arcamax.com>
To: <pgsql-general@postgresql.org>
Date: 2001-11-14T18:45:15Z
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.