Horton

Re: scale up (postgresql vs mssql)

Richard Huxton <dev@archonet.com>

View thread View on postgr.es
From: Richard Huxton <dev@archonet.com>
To: Eyal Wilde <eyal@impactsoft.co.il>
Cc: pgsql-performance@postgresql.org
Date: 2012-04-16T15:55:46Z
Lists: pgsql-performance 
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