From: | "Delao, Darryl W" <ddelao(at)ou(dot)edu> |
---|---|
To: | 'Neil Conway' <neilc(at)samurai(dot)com>, "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 17:15:21 |
Message-ID: | FC0CEBD77311DA499A67ADB355A24FA2546B6E@mail4.oulan.ou.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
Netstat shows live connections every 2 seconds with -c
-----Original Message-----
From: Neil Conway [mailto:neilc(at)samurai(dot)com]
Sent: Tuesday, March 11, 2003 11:12 AM
To: Delao, Darryl W
Cc: 'pgsql-novice(at)postgresql(dot)org'; 'pgsql-general(at)postgresql(dot)org'
Subject: Re: [GENERAL] General Performance questions
On Tue, 2003-03-11 at 09:14, Delao, Darryl W wrote:
> 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. 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! At this point, im assuming that netstat-c does
> not provide an accurate count of current connections. Anyone have any
> thoughts on this?
Is there a reason why you're trying to use netstat rather than the
pg_stat_activity system view?
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/monitoring-stats
.html
Cheers,
Neil
--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC
From | Date | Subject | |
---|---|---|---|
Next Message | Zachary Beane | 2003-03-11 17:24:40 | Unique indexes and updates |
Previous Message | eric soroos | 2003-03-11 17:12:50 | SMP-PPC spinlocks in 7.2.4? |
From | Date | Subject | |
---|---|---|---|
Next Message | David C.Oshel | 2003-03-11 19:31:00 | Apple's Java 1.4.1 seems to have broken DBVisualizer? |
Previous Message | Neil Conway | 2003-03-11 17:12:03 | Re: General Performance questions |