-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Fri, 11 Jan 2008 14:29:32 -0300 João Paulo Zavanela <joao_zava@xxxxxxxxx> 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----- ---------------------------(end of broadcast)---------------------------TIP 2: Don't 'kill -9' the postmaster
