Persistent Connections

From: postgres(at)countup(dot)de
To: pgsql-performance(at)postgresql(dot)org
Subject: Persistent Connections
Date: 2004-01-24 17:32:09
Message-ID: 20040124173209.933905A8170@kserver17.erfurt12.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

<html><head></head><body bgcolor="#ffffff" text="#000000" link="#000000" alink="#000000" vlink="#000000" marginwidth=10 marginheight=10 topmargin=10 leftmargin=10>Hi
<br>
<br>I have a php script and i make a pg_pconnect
<br>If i want to make 4-10 pg_query in that script
<br>Have i to close the connection at end of the script?
<br>(i would say yes, is it right?)
<br>
<br>Sorry I m a little bit confused about the persistent thing!!
<br>Is it smart to use persistent connections at all if i expect 100K Users to hit the script in an hour and the script calls up to 10-15 pg functions?
<br>I have at the mom one function but the server needs 500 ms, its a little bit too much i think, and it crashed when i had 20K users
<br>
<br>Thanks
<br>Bye
<br></body></html>

Attachment Content-Type Size
unknown_filename text/html 765 bytes

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Doug McNaught 2004-01-24 20:15:26 Re: High Performance/High Reliability File system on SuSE64
Previous Message Paul Ganainm 2004-01-24 17:31:56 Re: High Performance/High Reliability File system on SuSE64