Re: General Performance questions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Delao, Darryl W" <ddelao(at)ou(dot)edu>
Cc: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: General Performance questions
Date: 2003-03-11 15:37:53
Message-ID: 5158.1047397073@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

"Delao, Darryl W" <ddelao(at)ou(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Hauser 2003-03-11 16:06:00 Re: Installation question
Previous Message Delao, Darryl W 2003-03-11 15:36:19 Re: General Performance questions

Browse pgsql-novice by date

  From Date Subject
Next Message douggorley 2003-03-11 16:24:25 Re: [GENERAL] General Performance questions
Previous Message Delao, Darryl W 2003-03-11 15:36:19 Re: General Performance questions