| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL Portable |
| Date: | 2014-09-10 21:19:45 |
| Message-ID: | 5410C071.5090701@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Atkins | 2014-09-10 21:29:01 | Re: PostgreSQL Portable |
| Previous Message | Daniel Begin | 2014-09-10 21:00:01 | PostgreSQL Portable |