From: | Gregg Jaskiewicz <gryzman(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | table spaces |
Date: | 2013-03-09 17:51:10 |
Message-ID: | CAJY59_jHQ2Ln9_ZS9AXzygzEyZ9tOrRcenTzZHtWcZNvt2m7-g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Performance related question.
With Linux (centos 6.3+), 64bit, ext4 in mind, how would you guys go about
distributing write load across disks.
Lets say I have quite few disks, and I can partition them the way I want,
in mirror configuration (to get some hardware failure resilience). Should I
separate tables from indexes onto separate raids ?
I know WAL has to go on a separate disk, for added performance.
I'm looking for your experiences, and most importantly how do you go about
deciding which way is best. I.e. which combinations make sense to try out
first, short of all permutations :-)
Thanks.
--
GJ
From | Date | Subject | |
---|---|---|---|
Next Message | Bèrto ëd Sèra | 2013-03-09 18:08:21 | Re: table spaces |
Previous Message | Lonni J Friedman | 2013-03-09 16:16:26 | Re: postgres 9.0.2 replicated database is crashing |