[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]:
I am simulating only 1 client
[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]:
The parallelism happens even if my PC has only
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. In this
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 not
[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:
The problem I have encountered is that the sum
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
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
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 executing