Re: [postgis-users] outgrowing the standard Pg install
On Tue, Apr 6, 2010 at 1:40 AM, Ben Madin wrote: > 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? > Sweet! This is really helpful. However, I too am interested in splitting a single table across multiple disks. If you find out something before I find out and announce it here, please let me know. > 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 > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu --- Assertions are politics; backing up assertions with evidence is science === ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] outgrowing the standard Pg install
Puneet, a posting to the ADMIN list pgsql-admin will likely get you some good ideas. On Tue, Apr 6, 2010 at 2:21 AM, 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
Re: [postgis-users] outgrowing the standard Pg install
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
[postgis-users] outgrowing the standard Pg install
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
