On Fri, Mar 23, 2012 at 10:01 AM, Vick Khera <vivek@xxxxxxxxx> wrote: > On Wed, Mar 21, 2012 at 3:31 PM, Kjetil Nygård <polpot78@xxxxxxxxx> wrote: >> We wonder if someone could give some hardware / configuration specs for >> large PostgreSQL installations. >> We're interested in: >> - Number of CPUs >> - Memory on the server >> - shared_buffers >> - Size of the database on disk > > Just yesterday I purchased this system: > > Details: > CPU: 2 x Opteron 6212 (2.6GHz, 8-Core, G34, 16MB L3 Cache) 115W TDP, 32nm > RAM: 32GB (8 x 4GB) Operating at 1333MHz Max (DDR3-1333 ECC > Registered DIMMs) > NIC: Intel 82576 Dual-Port Gigabit Ethernet Controller - Integrated > Management: Integrated IPMI 2.0 & KVM with Dedicated LAN > PCIe 2.0 x8 - 1: LSI 9265-8i 6Gb/s SAS/SATA RAID (8-Port Int) with > 1GB DDR3 Cache (BBU Consumes 2nd PCI Slot) > PCIe 2.0 x8 - 2: No Item Selected > NOTE: SAS Drives or More Than 6 SATA Drives Require Controller > (See PCIe 2.0 Slot) > Hot-Swap Drive - 1: 40GB Intel 320 Series MLC (3Gb/s) 2.5" SATA SSD > Hot-Swap Drive - 2: 40GB Intel 320 Series MLC (3Gb/s) 2.5" SATA SSD > Hot-Swap Drive - 3: 160GB Intel 320 Series MLC (3Gb/s) 2.5" SATA SSD > Hot-Swap Drive - 4: 160GB Intel 320 Series MLC (3Gb/s) 2.5" SATA SSD > Hot-Swap Drive - 5: 160GB Intel 320 Series MLC (3Gb/s) 2.5" SATA SSD > Hot-Swap Drive - 6: 160GB Intel 320 Series MLC (3Gb/s) 2.5" SATA SSD > Hot-Swap Drive - 7: 160GB Intel 320 Series MLC (3Gb/s) 2.5" SATA SSD > Hot-Swap Drive - 8: 160GB Intel 320 Series MLC (3Gb/s) 2.5" SATA SSD > Optical Drive: Low-Profile DVD-ROM Drive > Power Supply: Redundant 700W Power Supply with PMBus - 80 PLUS > Gold Certified > **** Additional Components **** > Fastpath: LSI FastPath Software License (Requires 926x 928x controller) > > drives 1+2 RAID 1 for boot + OS > drives 3+4 RAID 1 for db logs > drives 5-8 RAID 10 for data > > The expected maximum size of the stored data is going to be about > 100GB, so the goal was to have the data area about 2x that limit since > they are SSDs and work optimally with lots of room to spare. > > My currently largest server has 22GB RAM and I specify 5GB as shared > buffers. Most important in tuning is to get your random_page_cost > right, and have enough checkpoint segments for your write load. would love to see some performance #s from your server when it's all set up... merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
