Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id C402762698B for ; Mon, 16 Apr 2012 12:56:04 -0300 (ADT) Received: from archon2012.plus.com ([80.229.41.160] helo=mail.archonet.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SJoHa-0007bk-SE for pgsql-performance@postgresql.org; Mon, 16 Apr 2012 15:56:03 +0000 Received: from [192.168.1.13] (ariel.office.archonet.com [192.168.1.13]) by mail.archonet.com (Postfix) with ESMTP id 7A4F32C3DCE; Mon, 16 Apr 2012 16:55:50 +0100 (BST) Message-ID: <4F8C4102.8050205@archonet.com> Date: Mon, 16 Apr 2012 16:55:46 +0100 From: Richard Huxton User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.3) Gecko/20120329 Icedove/10.0.3 MIME-Version: 1.0 To: Eyal Wilde CC: pgsql-performance@postgresql.org Subject: Re: scale up (postgresql vs mssql) References: In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201204/118 X-Sequence-Number: 46764 On 15/04/12 13:43, Eyal Wilde wrote: > > "version";"PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc > (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46), 64-bit" You've probably checked this, but if not it's worth making sure your disk I/O is roughly equivalent for the two operating-systems. It might be poor drivers on the CentOs system. Do you have two equivalent machines, or are you dual-booting? -- Richard Huxton Archonet Ltd