Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 039D9633280 for ; Mon, 23 Mar 2009 17:52:37 -0300 (ADT) 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 22769-09 for ; Mon, 23 Mar 2009 17:52:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp2.ca.com (smtp2.ca.com [141.202.248.13]) by mail.postgresql.org (Postfix) with ESMTP id CD0A363259A for ; Mon, 23 Mar 2009 17:52:33 -0300 (ADT) Received: from athena.ca.com ([130.200.164.17]) by smtp2.ca.com with Microsoft SMTPSVC(6.0.3790.3959); Mon, 23 Mar 2009 16:52:31 -0400 Message-ID: <49C7F676.1050604@ca.com> Date: Mon, 23 Mar 2009 13:52:06 -0700 From: Brian Cox User-Agent: Thunderbird 2.0.0.19 (X11/20081209) MIME-Version: 1.0 To: "Scott Marlowe [scott.marlowe@gmail.com]" CC: "pgsql-performance@postgresql.org" Subject: Re: multiple threads inserting into the same table Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 23 Mar 2009 20:52:31.0905 (UTC) FILETIME=[4923A910:01C9ABF9] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200903/337 X-Sequence-Number: 33259 Scott Marlowe [scott.marlowe@gmail.com] wrote: > Might you have a firewall that's killing the connections? What does > netstat -an on the client side say about these connections? I don't think so: 1) app and postgres are on the same machine and 2) this has been the set up for months and I don't think anyone has diddled with the machine. netstat -an | fgrep 5432 shows: [root@rdl64xeoserv01 log]# netstat -an | fgrep 5432 tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN tcp 0 0 127.0.0.1:5432 127.0.0.1:35996 ESTABLISHED tcp 0 0 127.0.0.1:5432 127.0.0.1:35999 ESTABLISHED tcp 0 0 127.0.0.1:5432 127.0.0.1:36017 ESTABLISHED tcp 0 0 127.0.0.1:5432 127.0.0.1:36019 ESTABLISHED tcp 0 0 127.0.0.1:5432 127.0.0.1:36018 ESTABLISHED tcp 0 0 127.0.0.1:5432 127.0.0.1:36005 ESTABLISHED tcp 0 0 127.0.0.1:5432 127.0.0.1:36001 ESTABLISHED tcp 0 0 127.0.0.1:5432 127.0.0.1:36013 ESTABLISHED tcp 0 0 127.0.0.1:5432 127.0.0.1:36008 ESTABLISHED tcp 0 0 127.0.0.1:5432 127.0.0.1:36011 ESTABLISHED tcp 0 0 130.200.163.80:5432 130.200.164.26:50481 ESTABLISHED tcp 0 0 :::5432 :::* LISTEN tcp 0 0 ::ffff:127.0.0.1:36001 ::ffff:127.0.0.1:5432 ESTABLISHED tcp 0 0 ::ffff:127.0.0.1:36005 ::ffff:127.0.0.1:5432 ESTABLISHED tcp 0 0 ::ffff:127.0.0.1:36008 ::ffff:127.0.0.1:5432 ESTABLISHED tcp 0 0 ::ffff:127.0.0.1:36011 ::ffff:127.0.0.1:5432 ESTABLISHED tcp 0 0 ::ffff:127.0.0.1:36013 ::ffff:127.0.0.1:5432 ESTABLISHED tcp 0 0 ::ffff:127.0.0.1:36017 ::ffff:127.0.0.1:5432 ESTABLISHED tcp 0 0 ::ffff:127.0.0.1:36019 ::ffff:127.0.0.1:5432 ESTABLISHED tcp 0 0 ::ffff:127.0.0.1:36018 ::ffff:127.0.0.1:5432 ESTABLISHED tcp 0 0 ::ffff:127.0.0.1:35996 ::ffff:127.0.0.1:5432 ESTABLISHED tcp 0 0 ::ffff:127.0.0.1:35999 ::ffff:127.0.0.1:5432 ESTABLISHED unix 2 [ ACC ] STREAM LISTENING 2640437 /tmp/.s.PGSQL.5432