Postgres Pro
Downloads
Home   >   mailing lists

Re: Windows performance - Mailing list pgsql-general

From Igor Neyman
Subject Re: Windows performance
Date
Msg-id A76B25F2823E954C9E45E32FA49D70ECCD5E892D@mail.corp.perceptron.com
Whole thread Raw
In response to Windows performance  ("Sterpu Victor" <victor@caido.ro>)
List pgsql-general
Tree view

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Sterpu Victor
Sent: Friday, February 12, 2016 10:38 AM
To: PostgreSQL General <pgsql-general@postgresql.org>
Subject: [GENERAL] Windows performance

 

Hello

 

Why is Postgres so slow on Windows compared to linux?

Can I do something to match the performance?

I have 2 servers:

- one is Windows 8, CPU XEON, 8 CORES,  32G of RAM - my test query runs in 17 seconds

- the other is Linux CPU XEON, 4 cores, 4 Gh of RAM - my test query runs in 2 seconds

I run the query on the same database.

 

CPU is not used at max on the servers, RAM is fine.

Is there a problem with Windows? My gues is that Windows is not using the hardware resources as it should be.

Can I do something to fix this?

 

Thank you.

 

 

More details would be helpful:

-          PG version

-          PG config on both servers

-          Actual query you are using

 

Regards,

Igor Neyman

 

 

pgsql-general by date:

Previous
From: subhan alimy
Date:
Subject: Postgresql Server Upgarde
Next
From: ioan ghip
Date:
Subject: Help me get started with moving away from Firebird