G'day Puneet, I'm no expert, but we have just started looking at using tablespaces to spread a database across multiple drives. You may already be across this.
http://www.postgresql.org/docs/8.4/interactive/manage-ag-tablespaces.html I haven't yet worked out if you can spread one table across multiple drives though. Also, I'm not sure if it works on windows? cheers Ben On 06/04/2010, at 14:21 , P Kishor wrote: > If my database grows beyond what is available on PostGIS/Pg computer, > what are my options? Can I add more drives to the computer and have > part of the database on one disk and another part on another disk? Or, > do I have to plan ahead, chop up my database into disk-sized chunks, > and install each chunk on separate machines? Here is an illustration > -- > > computer 1: Single disk, 1 TB space available, PGDATA in /usr/local/pgsql/data > > database is going to 5 TB eventually. I start on computer 1, when that > is filling up, I add external disks, so Postgres can just write > spillover from /usr/local/pgsql/data to /external/pgsql/data (is this > even possible?) > > OR > > computer 1: 1 TB space > computer 2: 1 TB space > .. and so on > > I divide my database into 1 TB chunks, install five instances of > PostGres/PostGIS on the five computers (what a nightmare) > > > > -- > Puneet Kishor > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
