From: | chenhj <chjischj(at)163(dot)com> |
---|---|
To: | "David Rowley" <david(dot)rowley(at)2ndquadrant(dot)com> |
Cc: | "Andres Freund" <andres(at)anarazel(dot)de>, "Heikki Linnakangas" <hlinnaka(at)iki(dot)fi>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: PATCH:do not set Win32 server-side socket buffer size on windows 2012 |
Date: | 2015-07-04 11:03:07 |
Message-ID: | 6e6561c4.155e1.14e58bbed69.Coremail.chjischj@163.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
2015-07-03 16:49:44,"David Rowley" <david(dot)rowley(at)2ndquadrant(dot)com> wrote:
I'm wondering what the original test setup was. I'm assuming psql and postgres both running on separate windows machines?
I've tested the patch just connecting to a database running on localhost and I'm not getting much of a speedup. Perhaps 1%, if that's not noise. I don't have enough hardware here to have client and server on separate machines, at least not with a stable network that goes through copper.
My original test environments is as the following
Environment1:
Server:Windows 2012(x64)
The host is a VM in a private cloud
Client:RHEL6(x64)
The host is another VM in the same private cloud
Network:1Gbit LAN
Environment2:
Server:Windows 2012(x64)
The host is a VM in a private cloud
Client:Windows 7(x64)
The host is a physical machine(in fact it is My PC).
Network:1Gbit LAN
This Patch should only can speedup the environment which satisfy the following conditions.
1. The OS of the server is Windows 2012 or Win8(but i only tested it in Windows 2012).
2. The client and the server is separate machines.
3. The performance bottleneck is network throughput.
4. The utilization rate of network bandwidth is not full(such as only 50% or lower).
Best Regards
Chen Huajun
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2015-07-04 11:25:59 | Re: postgresql-9.5alpha1 packaging |
Previous Message | drunken | 2015-07-04 08:14:43 | C# reading result from a function |