[postgis-users] outgrowing the standard Pg install

[Ben Madin]

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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users