Skip site navigation (1) Skip section navigation (2)

Re: multiple threads inserting into the same table

From: Brian Cox <brian(dot)cox(at)ca(dot)com>
To: "Scott Marlowe [scott(dot)marlowe(at)gmail(dot)com]" <scott(dot)marlowe(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: multiple threads inserting into the same table
Date: 2009-03-23 20:52:06
Message-ID: 49C7F676.1050604@ca.com (view raw or flat)
Thread:
Lists: pgsql-performance
Scott Marlowe [scott(dot)marlowe(at)gmail(dot)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(at)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




pgsql-performance by date

Next:From: Brian CoxDate: 2009-03-23 21:05:03
Subject: Re: multiple threads inserting into the same table
Previous:From: Scott MarloweDate: 2009-03-23 20:38:52
Subject: Re: multiple threads inserting into the same table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group