[postgis-users] outgrowing the standard Pg install

[P Kishor]

On Tue, Apr 6, 2010 at 1:40 AM, Ben Madin
<lists at remoteinformation.com.au> 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 at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at 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
=======================================================================