Re: General Performance questions - Mailing list pgsql-general

From Delao, Darryl W
Subject Re: General Performance questions
Date
Msg-id FC0CEBD77311DA499A67ADB355A24FA2546B6D@mail4.oulan.ou.edu
Whole thread Raw
In response to General Performance questions  ("Delao, Darryl W" <ddelao@ou.edu>)
Responses Re: General Performance questions  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Netstat -c shows both tcp and unix...at no time did they ever show more than
4 connections when the server reached its limit..

Whats a good way to check ps output?


Darryl


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Tuesday, March 11, 2003 9:38 AM
To: Delao, Darryl W
Cc: 'pgsql-novice@postgresql.org'; 'pgsql-general@postgresql.org'
Subject: Re: [GENERAL] General Performance questions

"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-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: General Performance questions
Next
From: Charles Hauser
Date:
Subject: Re: Installation question