Home / server / Questions / 67302
In Process
Matthieu
Asked: 2009-09-22 05:39:16 +0800 CST

Postgresql and Hardware

  • 772

Just a question about your Postgresql server(s). On what hardware are you running Postgresql? (CPU, Memory, Disk configuration, RAID...)

I'm planning to buy a dedicaded server for my postgresql instance: - Dell R710 - Xeon E5520 x 1 - RAM: 24GB - 2x146GB SAS 15K RAID1 for OS + pg_xlog - 3x450 SAS 15K RAID5 OR 4x450GB SAS 15K RAID10 for database.

What do you think about this config?

Thank You!

hardware

3 Answers

  1. That system looks pretty good. Unless your load is read-only, you will likely first bottleneck on I/O. Avoid RAID5, go for RAID10.

    Also, make sure you have plenty of battery backed cache memory on the RAID controller. That'll make a huge difference in write performance.

    • 4

  2. Database server hardware is dependent on what you will be doing with it. You need to at least take a guess at your load (database size, transactions per hour, etc, etc) before you can properly spec your servers.

    For instance, I run a postgresql database as part of an embedded system on a 1Ghz, single-core CPU with a 2Gig flash card for an HD and only 512megs of memory. Clearly this won't handle any kind of large loads, but for what we're doing it's perfectly fine.

    • 2

  3. The only Postgre server we have is our HP Command View server as it insists on using Postgre (has no MSSQL or Oracle option). It's a HP BL460c G6 with dual Xeon E5540's, 12GB DDR3 and dual 146GB 6G SAS SFF disks running W2K3 EE 32-bit with an Emulex 4Gbps FC mezz HBA. It runs just fine.

    • 1