> On Sun, Apr 20, 2008 at 6:00 PM, Dave Page <[EMAIL PROTECTED]> wrote:
> > On Fri, Apr 18, 2008 at 7:30 PM, Roberts, Jon
<[EMAIL PROTECTED]>
> wrote:
> >
> > I'm awaiting confirmation from the lead architect, but I believe
that
> > a single connection from pgAdmin will result in 1 connection to ea
On Sun, Apr 20, 2008 at 6:00 PM, Dave Page <[EMAIL PROTECTED]> wrote:
> On Fri, Apr 18, 2008 at 7:30 PM, Roberts, Jon <[EMAIL PROTECTED]> wrote:
>
> I'm awaiting confirmation from the lead architect, but I believe that
> a single connection from pgAdmin will result in 1 connection to each
> node in
On Fri, Apr 18, 2008 at 7:30 PM, Roberts, Jon <[EMAIL PROTECTED]> wrote:
> Now my system is actually running Greenplum which means I have 16 more
> (17 total) connections per user's connection because each segment host
> running gets a connection. So my measly 9 users actually are consuming
> 510
With pgAdmin, every window is a new connection to the database and this
alone wastes resources when you have lots of users.
select count(distinct usename) as unique_users,
count(*) as total_count,
count(*)/cast(count(distinct usename) as float8)
from pg_stat_activity;
For our s
