Thread: about the time of a process

about the time of a process

From
Manuel Trujillo
Date:
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

Re: about the time of a process

From
Manuel Trujillo
Date:
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

Re: about the time of a process

From
"Chad R. Larson"
Date:
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