From: | Erik Jones <erik(at)myemma(dot)com> |
---|---|
To: | Joshua D(dot) Drake <jd(at)commandprompt(dot)com> |
Cc: | João Paulo Zavanela <joao_zava(at)globo(dot)com>, "Grupo PostgreSQL" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Search connections created per day |
Date: | 2008-01-11 18:20:56 |
Message-ID: | C1E0F2C0-92B8-4A8D-8688-21C56D4101FB@myemma.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Jan 11, 2008, at 11:51 AM, Joshua D. Drake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Fri, 11 Jan 2008 14:29:32 -0300
> João Paulo Zavanela <joao_zava(at)globo(dot)com> wrote:
>
>> Hi there,
>>
>> I want to know how many connections is created simultaneously in data
>> base per day.
>
> Entirely depends on your machine. I wouldn't suggest having more
> than a
> 1000 open at any given time though. Also take a look at connection
> pooling.
>
>> Are there some table where i can search it?
>
> pg_stat_activity
>
>> All users is connected in the database with postgres user.
I think he was looking for some kind of logging/reporting of how many
connections have actually been made for a given day. He should be
looking at turning on log_connections and then parsing his logs for
connection entries.
Erik Jones
DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Jones | 2008-01-11 18:22:20 | Re: Online Oracle to Postgresql data migration |
Previous Message | Scott Marlowe | 2008-01-11 18:14:59 | Re: Online Oracle to Postgresql data migration |