Postgresql which raid

You can do this when you create the partitions. This should provide you the best speed in terms of IO access. Therefore, the suggestion to go with RAID 10 is good. And for database performance, use more faster disks even if they're smaller rather than fewer slower disks even if they're bigger. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Learn more. Asked 11 years, 10 months ago. Active 11 years, 10 months ago. Viewed 10k times. I'm new to configuring RAID and postgres and appreciate the advice. Improve this question. Add a comment. Active Oldest Votes. This is also another point of consideration while tuning the file systems. Over the past 10 years, storage systems have become more intelligent, which results in improved performance with less manual design work.

However, storage systems may still be a pain point if not correctly chosen, since there are some trade-offs with each solution. Typical wisdom with Postgres has been to use RAID 10 mirrored and striped for the best performance and redundancy.

However, that option can be expensive as you need twice the number of disks in order to mirror each one. The advantage with RAID 5 and 6 is that fewer drives are typically required. DAS Direct Attached Storage refers to connecting your drives to the server, usually using the slots which are integrated into the server inside the drive cage. Unlike SAN as discussed in section 3. There are exceptions to this; some systems may have external drive enclosures that are directly attached to the server via SCSI or fiber channel, though they are less commonly seen.

If there is more than one interface on DAS, data can be shared with multiple other servers. DAS storage can usually provide redundancy; most modern servers with internal storage will include a RAID adaptor that can be configured with mirroring. If this is not the case, the Storage Area Network should be evaluated as well. A Storage Area Network SAN is essentially a group of drives connected to at least one server providing simultaneous access to the drives to one or more servers on the network.

One of the major benefits of using SAN is the total number of drives that can be attached. SANs typically also provide redundancy options for the entire storage system - drives, power supplies, network interfaces and controllers, which are suitable for any enterprise company. Create a free Team What is Teams? Learn more. Asked 10 years, 8 months ago.

Active 10 years, 8 months ago. Viewed 2k times. Fault tolerance is less important, it can be 1 or 2 disks. Space is the least important factor. Even 1T will be enough. Improve this question.

Sergey Sergey 41 2 2 bronze badges. Add a comment. Active Oldest Votes. Improve this answer.