| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Jeff Amiel <becauseimjeff(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Advice on contingency plan for DAS array with separate local WAL drives |
| Date: | 2010-06-14 13:24:59 |
| Message-ID: | 4C162DAB.6010904@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jeff Amiel wrote:
> Recently migrated to a shiny new 8.4.4 postgres instance....data stored on attached storage array. Transaction logs stored on 2 local mirrored drives (local to the database server itself) for best performance.
>
Have you benchmarked that this really helps? Splitting the WAL out onto
a drive pair can help a lot in some cases, but given a large attached
array the improvement tends to be minimal relative to just lumping those
writes in with the rest of the array. The easy way out of your problem
is to just not put the WAL on the local drives, and instead use them for
things like temp file storage.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Gage | 2010-06-14 13:29:01 | Re: Hosting without pgcrypto functions. There are other solutions? |
| Previous Message | Merlin Moncure | 2010-06-14 13:20:56 | Re: Hosting without pgcrypto functions. There are other solutions? |