Postgres Pro
Downloads
Home   >   mailing lists

Postgres performance on Linux and Windows - Mailing list pgsql-performance

From Dusan Misic
Subject Postgres performance on Linux and Windows
Date
Msg-id CAGdZ+NC=kZ1TqPp_RPxLkYrP3eKqC+8Wf17S2P5QPn_5_WiLPg@mail.gmail.com
Whole thread Raw
Responses Re: Postgres performance on Linux and Windows  (Andy Colson <andy@squeakycode.net>)
Re: Postgres performance on Linux and Windows  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Postgres performance on Linux and Windows  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-performance
Tree view

I had done some testing for my application (WIP) and I had executed same SQL script and queries on real physical 64-bit Windows 7 and on virtualized 64-bit CentOS 6.

Both database servers are tuned with real having 8 GB RAM and 4 cores, virtualized having 2 GB RAM and 2 virtual cores.

Virtualized server crushed real physical server in performance in both DDL and DML scripts.

My question is simple. Does PostgreSQL perform better on Linux than on Windows and how much is it faster in your tests?

Thank you for your time.

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Performance penalty when using WITH
Next
From: Andy Colson
Date:
Subject: Re: Postgres performance on Linux and Windows