Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 7AB206348EC
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed,  6 Jan 2010 13:45:24 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 10845-03-8
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed,  6 Jan 2010 17:45:12 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f227.google.com (mail-fx0-f227.google.com
	[209.85.220.227])
	by mail.postgresql.org (Postfix) with ESMTP id 90A0A635116
	for <pgsql-performance@postgresql.org>;
	Wed,  6 Jan 2010 12:18:40 -0400 (AST)
Received: by fxm27 with SMTP id 27so2853140fxm.3
	for <pgsql-performance@postgresql.org>;
	Wed, 06 Jan 2010 08:18:39 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=6QC22YR+24JPhEDPvP9rcFUS7FSOcJkjznVZCmLgMt4=;
	b=RxLmm4f9Cxo245P6EUTgTAt8LT4IIn71cvLse7eaXVVz2OPaO7RZ1fl9ba5pF9LPI5
	wXHupKeatTQ6IR7umWYuNp06FazI7z8pYic2EQi5or2y88p1PHPEg9K8CZGNrSfQsnxM
	K4/3JmzHVJQZPYyxrWqPVmz5OfMx+Xle+pT2g=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=QNxS6L1r0yymbkprv9TQV8y+IMmAH3M3LemIbkN7SBi+b/H+AA3fgEoxzEuIx+cWxL
	eFqdsoqwg5WTax7Q9oCmm4t7BbTsZQeDAWLs+RJ/oa07QIFTNk3LZO3+1gl9xqKh1nyD
	vZnp3iHZPEwy0LTAjOeyQT0HfYAGZZkuexEJ0=
MIME-Version: 1.0
Received: by 10.239.163.195 with SMTP id q3mr1874078hbd.108.1262794718904;
	Wed, 06 Jan 2010 08:18:38 -0800 (PST)
In-Reply-To: <4B4416A7.1040808@postnewspapers.com.au>
References: <daed64561001041812s602a3098l686f630d6448835f@mail.gmail.com>
	<4B4354B0.8030400@squeakycode.net>
	<daed64561001051925k26682e50ue1792e7032a75bd5@mail.gmail.com>
	<4B4416A7.1040808@postnewspapers.com.au>
Date: Wed, 6 Jan 2010 11:18:38 -0500
Message-ID: <603c8f071001060818u7fac69a3sde62c01c3641d053@mail.gmail.com>
Subject: Re: pg_connect takes 3.0 seconds
From: Robert Haas <robertmhaas@gmail.com>
To: Craig Ringer <craig@postnewspapers.com.au>
Cc: Dmitri Girski <mitek17@gmail.com>, Andy Colson <andy@squeakycode.net>,
	pgsql-performance@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.313 tagged_above=-10 required=5 tests=AWL=-2.690,
	BAYES_40=-0.185, FH_DATE_PAST_20XX=3.188
X-Spam-Level: 
X-Archive-Number: 201001/60
X-Sequence-Number: 36940

On Tue, Jan 5, 2010 at 11:50 PM, Craig Ringer
<craig@postnewspapers.com.au> wrote:
> Wireshark is your friend.

+1.  I think if you put a packet sniffer on the interface you are
connecting from it will become clear what the problem is in short
order.

...Robert