Re: PostgreSQL Portable

I just started to look at PostgreSQL to implement a large GIS DB (1Tb).  The data must reside in an external disk with eSATA connection and may be moved to different locations (and Windows desktops/laptops). I was looking to install PostgreSQL and PostGIS extensions on each PC (setting-up the proper PGDATA directory to the external disk) until I read about PostgreSQL and PgAdmin Portable …

 

http://sourceforge.net/projects/pgadminportable/

http://sourceforge.net/projects/postgresqlportable/

 

Is that a viable alternative considering the expected size of the DB? Any comments or proposal would be appreciated J

a 1TB database on a single disk drive, presumably 7200rpm, will not perform very well under any sort of concurrency, or doing any sort of operation that requires aggregating a lot of rows.

also, Windows disables writeback caching on external disks, this will greatly slow down update transactions.

-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast