On 02/12/2016 07:37 AM, Sterpu Victor wrote:
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
Assuming the version of Postgres is the same on both machine. In any case what are the versions on the machines?
I run the query on the same database.
What is the query and what is the output of EXPLAIN ANALYZE?
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
I will pass on this.
the hardware resources as it should be. Can I do something to fix this?
Are the settings in the postgresql.conf files the same?
Thank you.
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
