Thread: about the time of a process
Hi. Another question... How many take to time a backend process if it haven't gos "traffic" (or run any query), to dead?? Have postgresql a SET command for determinate this question? I will apologize about my bad english... sorry please. Thank's for all. -- Manuel Trujillo manueltrujillo@dorna.es Technical Engineer http://www.motograndprix.com Dorna Sports S.L. +34 93 4702864
On Sat, Sep 29, 2001 at 02:28:08PM -0400, Bruce Momjian wrote: > > 7.2 will have EXPLAIN ANALYZE. > > Another question... How many take to time a backend process if > > it haven't gos "traffic" (or run any query), to dead?? > > Have postgresql a SET command for determinate this question? > > I will apologize about my bad english... sorry please. Of course... Well, we have a php compiled with Apache. It make a persistent connection with the DB. But, if this connection is not clossedby the php, how many time is take for postgres to close the bakcend opened by the php thread? Or by the another way, if I open a backend via psql connection, and I forget this and go out to my home... I think the postgresqlhave a mechanism to close the connection if haven't got any "traffic" beetwen the psql client and the server. I don't know: 1- If postgresql server have this propertie. 2- If have this propertie, how work. -- Manuel Trujillo manueltrujillo@dorna.es Technical Engineer http://www.motograndprix.com Dorna Sports S.L. +34 93 4702864
At 02:20 PM 9/28/01 +0200, Manuel Trujillo wrote: >I will apologize about my bad english... sorry please. This reply is =way= off-topic, but since this group has a large readership for whom English is not their primary language... Perhaps it would have been easier for you to have written in Spanish, and then used the "Babel fish" found at "http://world.altavista.com" to help you with the translation. I'm continually impressed at how hard some people work to communicate on these mailing lists. I have a mental image of someone sitting with a Spanish/English dictionary in their lap, fussing away for an hour or so to ask their simple but important to them question. Computers can help. Example: Quizás habría sido más fácil que usted escriba en español, y entonces utilizado los " piscados de Babel " encontró en " http://world.altavista.com " para ayudarle con la traducción. Me impresionan continuamente en cómo es duro alguna gente trabaja para comunicar en éstos listas el enviar. Tengo una imagen mental alguien que se sienta con un diccionario de Spanish/English en su regazo, quejándose lejos por una hora o pedir tan su simple pero importante para ellos pregunta. Los ordenadores pueden ayudar. -crl -- Chad R. Larson (CRL22) chad@eldocomp.com Eldorado Computing, Inc. 602-604-3100 5353 North 16th Street, Suite 400 Phoenix, Arizona 85016-3228