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
Subject: [GENERAL] Windows performance
Hello
Why is Postgres so slow on Windows compared to linux?
Can I do something
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 code bases: there are n
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 ste
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.
that
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 other is Linux CPU XEO
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 pasted it at the end of
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
gu
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
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
>>
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 G
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
11 matches
Mail list logo
