On Thu, Aug 19, 2010 at 2:07 AM, Philippe Rimbault <primbault@xxxxxx> wrote: > Hi, > > I'm having a strange performance result on a new database server compared to > my simple desktop. > > The configuration of the new server : > - OS : GNU/Linux Debian Etch x86_64 > - kernel : Linux 2.6.26-2-vserver-amd64 #1 SMP Sun Jun 20 20:40:33 UTC > 2010 x86_64 GNU/Linux > (tests are on the "real server", not on a vserver) > - CPU : 2 x Six-Core AMD Opteron(tm) Processor 2427 @ 2.20GHz > - RAM : 32 Go > The configuration of my desktop pc : > - OS : GNU/Linux Debian Testing i686 > - kernel : Linux 2.6.32-5-686 #1 SMP Tue Jun 1 04:59:47 UTC 2010 i686 > GNU/Linux > - CPU : Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz > - RAM : 2 Go PERFORMANCE STUFF DELETED FOR BREVITY > Do you think it's a 32bit/64bit difference ? No, it's likely that your desktop has much faster CPU cores than your server, and it has drives that may or may not be obeying fsync commands. Your server, OTOH, has more cores, so it's likely to do better under a real load. And assuming it has more disks on a better controller it will also do better under heavier loads. So how are the disks setup anyway? -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance