| From: | Joachim Worringen <joachim(dot)worringen(at)iathh(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Considering Solid State Drives |
| Date: | 2010-11-11 16:34:50 |
| Message-ID: | 4CDC1B2A.4060908@iathh.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am 11.11.2010 16:40, schrieb David Siebert:
> ZFS has an option to use an SSD as cache for the spinning drives. ZFS
> under Solaris has turned in some really good IO numbers. The problem is
> with the new Sun I am not feeling so good about the open nature of
> Solaris. ZFS performance under BSD I have read does not match ZFS under
> Solaris.
Very true. Also, we experienced (with a 32-core/64GB Sun X4600 machine
and a direct-attached storage array with 24 10k-spindles) that
PostgreSQL scaled *badly* (with the number of active, long-running
queries) when using ZFS. Installing CentOS with XFS, the same hardware
delivered very good scaling and higher absolute performance.
Admitted, this were more or less out-of-the-box configurations (but we
did some tuning with ZFS, which resulted in a 2x speedup - still not
enough). But the difference was drastic. We went with Linux/XFS then.
Joachim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2010-11-11 16:45:33 | Re: good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9 |
| Previous Message | David Siebert | 2010-11-11 15:40:45 | Re: Considering Solid State Drives |