Re: [GENERAL] General Performance questions - Mailing list pgsql-novice

From Tom Lane
Subject Re: [GENERAL] General Performance questions
Date
Msg-id 5158.1047397073@sss.pgh.pa.us
Whole thread Raw
In response to General Performance questions  ("Delao, Darryl W" <ddelao@ou.edu>)
Responses Apple's Java 1.4.1 seems to have broken DBVisualizer?
List pgsql-novice
"Delao, Darryl W" <ddelao@ou.edu> writes:
> I have been monitoring netstat -c on my db server for a few days now.  I am
> trying to determine if when I see a postgres connection, if that is indeed
> just 1 connection or if it is a bunch of connections tied up in 1.

One connection is one connection.

> The
> other day I had postgres set to a limit of 128 connections, and that was
> reached.  But at no time while monitoring netstat -c did I see 128
> connections!

Are you watching both Unix and TCP sockets?  Have you compared netstat
to ps output?

            regards, tom lane

pgsql-novice by date:

Previous
From: "Delao, Darryl W"
Date:
Subject: General Performance questions
Next
From: "Delao, Darryl W"
Date:
Subject: Re: [GENERAL] General Performance questions