From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | João Paulo Zavanela <joao_zava(at)globo(dot)com> |
Cc: | "Grupo PostgreSQL" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Search connections created per day |
Date: | 2008-01-11 17:51:10 |
Message-ID: | 20080111095110.651c5546@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----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.
>
Sincerely,
Joshua D. Drake
> Thanks.
> João Paulo Zavanela
>
>
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 9: In versions below 8.0,
> the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFHh6yOATb/zqfZUUQRAuqCAKCFHs1tp6Zar+2FIEhipJaSWskEowCbBp9y
TmFyoOPqqYajvLQqy36EB0k=
=v8pM
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Harrison | 2008-01-11 18:02:01 | Online Oracle to Postgresql data migration |
Previous Message | João Paulo Zavanela | 2008-01-11 17:29:32 | Search connections created per day |