Re: table spaces

From: Gregg Jaskiewicz <gryzman(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: table spaces
Date: 2013-03-12 21:31:33
Message-ID: CAJY59_hiGizAWnc8E7RGyYb7phN3n7m10Xo3S00QbTk5Wzpr6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ok,

So by that token (more drives the better), I should have raid 5 (or
whichever will work) with all 6 drives in it ?

I was thinking about splitting it up like this. I have 6 drives (and one
spare). Combine them into 3 separate logical drives in mirrored
configuration (for some hardware redundancy).
And use one for base system, and some less frequently read tables, second
one for WAL, third one for whatever tables/indexes happen to need separate
space (subject to characterisation outcome).

I was basically under impression that separating WAL is a big plus. On top
of that, having separate partition to hold some other data - will do too.
But it sounds - from what you said - like having all in single logical
drive will work, because raid card will spread the load amongst number of
drives.
Am I understanding that correctly ?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2013-03-12 21:54:15 Age of the WAL?
Previous Message Emre Hasegeli 2013-03-12 19:17:33 Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks