Re: PostgreSQL Portable

John R Pierce <pierce@xxxxxxxxxxxx> · Wed, 10 Sep 2014 14:19:45 -0700



    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