Re: [GENERAL] Windows performance

2016-02-15 Thread Igor Neyman
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@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 W

Re: [GENERAL] Windows performance

2016-02-14 Thread George Neuner
On Fri, 12 Feb 2016 14:43:55 -0800, John R Pierce wrote: >On 2/12/2016 2:28 PM, George Neuner wrote: >> In Linux the distinction between a "workstation" and a "server" is >> largely a matter of system configuration. Windows "desktop" and >> "server" editions are different

[GENERAL] Windows performance

2016-02-12 Thread Sterpu Victor
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

Re: [GENERAL] Windows performance

2016-02-12 Thread Sterpu Victor
There are some differences that I haven't mentioned. Postgres on Linux is PostgreSQL 9.1.4 64 bit Postgres on Windows is PostgreSQL 9.5.0, compiled by Visual C++ build 1800, 64-bit The query is very big but I pasted it at the end of the mail with the EXPLAIN ANALYZE. I runned the queries many

Re: [GENERAL] Windows performance

2016-02-12 Thread Adrian Klaver
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

Re: [GENERAL] Windows performance

2016-02-12 Thread Tim Clarke
On 12/02/16 15:45, Adrian Klaver wrote: > 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

Re: [GENERAL] Windows performance

2016-02-12 Thread John R Pierce
On 2/12/2016 8:09 AM, Sterpu Victor wrote: The query is very big but I pasted it at the end of the mail with the EXPLAIN ANALYZE. I ran that explain through Depesz's 'explain' analyzer. http://explain.depesz.com/s/c7ts there's a lot(!) of small steps in that query. I'm going to hazard a

Re: [GENERAL] Windows performance

2016-02-12 Thread Jeff Janes
On Fri, Feb 12, 2016 at 8:09 AM, Sterpu Victor wrote: > There are some differences that I haven't mentioned. > Postgres on Linux is PostgreSQL 9.1.4 64 bit > Postgres on Windows is PostgreSQL 9.5.0, compiled by Visual C++ build 1800, > 64-bit > > The query is very big but I

Re: [GENERAL] Windows performance

2016-02-12 Thread Adrian Klaver
On 02/12/2016 11:22 AM, John R Pierce wrote: On 2/12/2016 8:09 AM, Sterpu Victor wrote: The query is very big but I pasted it at the end of the mail with the EXPLAIN ANALYZE. I ran that explain through Depesz's 'explain' analyzer. http://explain.depesz.com/s/c7ts there's a lot(!) of small

Re: [GENERAL] Windows performance

2016-02-12 Thread George Neuner
On Fri, 12 Feb 2016 15:37:37 +, "Sterpu Victor" wrote: >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

Re: [GENERAL] Windows performance

2016-02-12 Thread John R Pierce
On 2/12/2016 2:28 PM, George Neuner wrote: In Linux the distinction between a "workstation" and a "server" is largely a matter of system configuration. Windows "desktop" and "server" editions are different code bases: there are no magic settings that can make one equivalent to the other.