On 9/10/2014 2:00 PM, Daniel Begin wrote:
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