Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 21C3A6330F5
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue, 17 Feb 2009 17:15:13 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 44212-06-2
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue, 17 Feb 2009 17:15:07 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mh3.mail.rice.edu (mh3.mail.rice.edu [128.42.199.10])
	by mail.postgresql.org (Postfix) with ESMTP id D55EB63316B
	for <pgsql-performance@postgresql.org>;
	Tue, 17 Feb 2009 17:14:59 -0400 (AST)
Received: from mh3.mail.rice.edu (localhost.localdomain [127.0.0.1])
	by mh3.mail.rice.edu (Postfix) with ESMTP id 3AC6432403D
	for <pgsql-performance@postgresql.org>;
	Tue, 17 Feb 2009 15:14:57 -0600 (CST)
X-Virus-Scanned: by amavis-2.6.0 at mh3.mail.rice.edu
Received: from mh3.mail.rice.edu ([127.0.0.1])
	by mh3.mail.rice.edu (mh3.mail.rice.edu [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id F7a79o2M8s3z for <pgsql-performance@postgresql.org>;
	Tue, 17 Feb 2009 15:14:57 -0600 (CST)
Received: from cooker.cnx.rice.edu (cooker.cnx.rice.edu [168.7.5.70])
	by mh3.mail.rice.edu (Postfix) with ESMTP id 1C5FB324039
	for <pgsql-performance@postgresql.org>;
	Tue, 17 Feb 2009 15:14:57 -0600 (CST)
Received: from reedstrm by cooker.cnx.rice.edu with local (Exim 3.36 #1
	(Debian)) id 1LZXHL-0000th-00
	for <pgsql-performance@postgresql.org>; Tue, 17 Feb 2009 15:14:55 -0600
Date: Tue, 17 Feb 2009 15:14:55 -0600
From: "Ross J. Reedstrom" <reedstrm@rice.edu>
To: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: TCP network cost
Message-ID: <20090217211454.GB23707@cooker>
Mail-Followup-To: "Ross J. Reedstrom" <reedstrm>,
	pgsql-performance <pgsql-performance@postgresql.org>
References: <20090217070403.GB2486@cooker>
	<1ca1c1410902171013q478f2620n13fcd68cb8b3d911@mail.gmail.com>
	<20090217070403.GB2486@cooker>
	<3FAF940B-9B0B-4DBA-8728-6096022129DF@infogears.com>
	<alpine.DEB.1.10.0902170032440.25606@asgard.lang.hm>
	<20090217070403.GB2486@cooker>
	<3FAF940B-9B0B-4DBA-8728-6096022129DF@infogears.com>
	<20090217200416.GA23707@cooker>
	<B7A2E4DA-A137-46F5-8643-2EF3772F4D2C@infogears.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <B7A2E4DA-A137-46F5-8643-2EF3772F4D2C@infogears.com>
User-Agent: Mutt/1.5.13 (2006-08-11)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200902/202
X-Sequence-Number: 32783

On Tue, Feb 17, 2009 at 01:59:55PM -0700, Rusty Conover wrote:
> 
> On Feb 17, 2009, at 1:04 PM, Ross J. Reedstrom wrote:
> 
> 
> What is the client software you're using?  libpq?
> 

python w/ psycopg (or psycopg2), which wraps libpq. Same results w/
either version.

I think I'll try network sniffing to see if I can find where the
delays are happening.

Ross