Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id E80C4AE0198 for ; Sun, 1 Apr 2012 22:11:35 -0300 (ADT) Received: from relay3-d.mail.gandi.net ([217.70.183.195]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SEVnx-0001ML-Bz for pgsql-performance@postgresql.org; Mon, 02 Apr 2012 01:11:34 +0000 X-Originating-IP: 217.70.178.141 Received: from mfilter13-d.gandi.net (mfilter13-d.gandi.net [217.70.178.141]) by relay3-d.mail.gandi.net (Postfix) with ESMTP id 507A5A8068; Mon, 2 Apr 2012 03:11:10 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at mfilter13-d.gandi.net Received: from relay3-d.mail.gandi.net ([217.70.183.195]) by mfilter13-d.gandi.net (mfilter13-d.gandi.net [10.0.15.180]) (amavisd-new, port 10024) with ESMTP id LPn7N08SPGsR; Mon, 2 Apr 2012 03:11:08 +0200 (CEST) X-Originating-IP: 98.27.54.176 Received: from [192.168.10.146] (cpe-098-027-054-176.nc.res.rr.com [98.27.54.176]) (Authenticated sender: adsend@dunslane.net) by relay3-d.mail.gandi.net (Postfix) with ESMTPSA id 1510FA806E; Mon, 2 Apr 2012 03:11:05 +0200 (CEST) Message-ID: <4F78FCA7.8010307@dunslane.net> Date: Sun, 01 Apr 2012 21:11:03 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.1) Gecko/20120216 Thunderbird/10.0.1 MIME-Version: 1.0 To: Claudio Freire CC: Andy , Ofer Israeli , "pgsql-performance@postgresql.org" Subject: Re: TCP Overhead on Local Loopback References: <217DDBC2BB1E394CA9E7446337CBDEF20102DEDB4A58@il-ex01.ad.checkpoint.com> <1333317709.70394.YahooMailNeo@web111301.mail.gq1.yahoo.com> <4F78EABF.2050209@dunslane.net> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201204/6 X-Sequence-Number: 46652 On 04/01/2012 08:29 PM, Claudio Freire wrote: > On Sun, Apr 1, 2012 at 8:54 PM, Andrew Dunstan wrote: >>> You could try using Unix domain socket and see if the performance >>> improves. A relevant link: >> >> He said Windows. There are no Unix domain sockets on Windows. (And please >> don't top-post) > Windows supports named pipes, which are functionally similar, but I > don't think pg supports them. > Correct, so telling the OP to have a look at them isn't at all helpful. And they are not supported on all Windows platforms we support either (specifically not on XP, AIUI). cheers andrew