From: | Benjamin Adams <freebsdworld(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | External Storage of data dir |
Date: | 2012-08-10 13:59:31 |
Message-ID: | CA+0XLA+ywGeeBWYuRyEbrtVNmkN7qG3sjMroM6wSGTn+nO5ckg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm looking to expand my old home server running on Ubuntu Server
I only have ~100 GB system drive (4 HDs, Raid 5, SAS). Backups are to
a USB 1.1 (2TB)
I do have lots of spare old SATA HD's with a spare 1GB connection to server box.
I have been looking into getting an iSCSI system to run my /data dir from.
I would be doing a direct connect no switch or router.
Server <--------> iSCSI (6 Bay, Raid 5 or 10)
I have read GB can get 130 Mps.
Wondering how this would effect postgres performance or even if it would work.
Before I spend the money.
(don't have to money to buy a new server)
I know remount mounting issue maybe an issue.
Anyone know of benchmarks comparing local and remote storage for Postgres.
Thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Laszlo Fogas | 2012-08-10 14:14:54 | Re: slowness what only full vacuum can solve |
Previous Message | Albe Laurenz | 2012-08-10 13:56:27 | Re: Postgres and Upstart |