2009/3/16 [email protected] <[email protected]>: > Hello List, > > i would like to pimp my postgres setup. To make sure i dont have a slow > hardware, i tested it on three diffrent enviorments: > 1.) Native Debian Linux (Dom0) > 2.) Debian Linux in Xen (DomU) > 3.) Blade with SSD Disk > > Here are my results: http://i39.tinypic.com/24azpxg.jpg > > Here is my postgres config: http://pastebin.com/m5e40dbf0
Ah, but... is this for postfix? Or did you mean postgres-users@ :) Anyway, this could be interesting on a busy (the definition of "busy" is subjective) system, because Postfix and Postgres are both I/O bound to some extent. Competition could cause interesting things to happen. > On Hardware 1 + 2 (native linux and debian) i have the following Hardware > underneath: > -------------------------------------------------------------------------------------------------------------------------------------------------------- > - ARC-1220 8-Port PCI-Express > - Raid 6 > - 1x Quadcore Intel(R) Xeon(R) CPU E5320 @ 1.86GHz > > The Blade: > ---------------------------- > - 2x 16GB SSD set up in striping mode (Raid 0) > - 2x Quardcore Intel(R) Xeon(R) CPU E5420 @ 2.50GHz Need to know how much RAM these systems have, what kind of drives on the ARC-1220, etc. And noone would run RAID-0 unless they were feeling real lucky, or have ephemeral data, etc... > Any idea why my performance colapses at 2GB Database size? Sure, have you tuned postgres at all? Your postgres config isn't as useful as it could be without more system info. http://www.anchor.com.au/hosting/dedicated/Tuning_PostgreSQL_on_your_Dedicated_Server
