From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | "Delao, Darryl W" <ddelao(at)ou(dot)edu> |
Cc: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'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 20:27:56 |
Message-ID: | Pine.LNX.4.33.0303111327230.16980-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
On many boxes, something like:
ps ax |grep postgres
will do.
On Tue, 11 Mar 2003, Delao, Darryl W wrote:
> 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(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Tuesday, March 11, 2003 9:38 AM
> To: Delao, Darryl W
> Cc: 'pgsql-novice(at)postgresql(dot)org'; 'pgsql-general(at)postgresql(dot)org'
> Subject: Re: [GENERAL] General Performance questions
>
> "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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-03-11 20:32:10 | Re: Installation question |
Previous Message | Joseph Shraibman | 2003-03-11 20:17:29 | Re: ERROR: out of free buffers: time to abort! |
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-03-11 20:45:08 | Re: General Performance questions |
Previous Message | Amit_Wadhwa | 2003-03-11 19:31:13 | Re: export from postgres into dbf |