| From: | Fathi Ben Nasr <fathi(dot)engineer(at)gnet(dot)tn> | 
|---|---|
| To: | postgres list <pgsql-general(at)postgresql(dot)org> | 
| Subject: | Re: Close idle connections | 
| Date: | 2002-06-25 07:22:15 | 
| Message-ID: | 200206251049.g5PAnd918374@smtp.planet.tn | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
You need to check your php app and see if you have in each page a
pg_close($socket) statement. If your app uses persistent connections to
reduce execution times, you should have only one connection per user.
Horde/imp is one app that uses a lot of connections, so if this is your
application, try to see if a recent version of horde/imp corrects this
problem.
Uros Gruber a écrit :
> Hi!
>
> i want to know if there is possible to close idle
> connections. I have some app in php but there is a lot of
> open connections idleing and sometimes i get to many
> connections.
>
> --
> lp,
>  Uros                         mailto:uros(at)sir-mag(dot)com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
(See attached file: smime.p7s)
| Attachment | Content-Type | Size | 
|---|---|---|
| =?iso-8859-1?Q?smime.p7s?= | application/octet-stream | 1.9 KB | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Deepali | 2002-06-25 07:22:54 | Syntax to create objects in Postgresql | 
| Previous Message | tdn | 2002-06-25 06:44:05 | altering column width |