[Camilo Porto]
> Date: Tue, 30 Oct 2007 16:09:01 +
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] URGENT HELP about 'duration' stats
> CC: pgsql-hackers@postgresql.org
>
> 2007/10/30, Camilo Porto <[EMAIL PROTECTED]>:
>
Camilo Porto wrote:
> In some tests I have done, I have found these results:
> - Total Time interval which BenchmarkSQL submitted queries = 30 seconds
>
> - sum of executor's duration time during this period of time = 2
> minutes and 36 seconds!! (5x longer than total time)
Are you sure you're
2007/10/30, Camilo Porto <[EMAIL PROTECTED]>:
> > > I am simulating only 1 client with the Benchmark. Can 1 Client submit
> > > parallel queries, in single-processor enviroment?
> > If this client uses two connections, you can run two queries in paralell.
> The client uses only 1 connection. I
[Camilo Porto]
> Date: Sat, 27 Oct 2007 18:12:28 +0100
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] URGENT HELP about 'duration' stats
> CC: pgsql-hackers@postgresql.org
>
> 2007/10/27, Camilo Porto <[EMAIL PROTECTED]>:
>
&
2007/10/27, Camilo Porto <[EMAIL PROTECTED]>:
> The parallelism happens even if my PC has only one processor?
PostgreSQL creates a separate process for each client connection -
whether you have one CPU or more.
> Each query is executed in a separeted Thread?
No threads, at least on Unix. Regular
[Camilo Porto]
> To: [EMAIL PROTECTED]
> CC: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] URGENT HELP about 'duration' stats
> Date: Fri, 26 Oct 2007 23:06:22 -0400
> From: [EMAIL PROTECTED]
>
> Camilo Porto <[EMAIL PROTECTED]> writes:
> >
Camilo Porto <[EMAIL PROTECTED]> writes:
> The problem I have encountered is that the sum of executor's
> duration time is, *sometimes*, bigger than the total time interval in
> which the statements had been executed!! And this makes no sense!
Umm ... why not? If you have, say, two queries execut
Hi,
I
have been doing my master degree research and I am using Postgresql
8.2.5. I would appreciate if anyone could help me, ASAP, concerning the
following question:
How can I obtain the time spent by the Postgresql EXECUTOR during a given
time interval?
I am trying to get the above info
