On 25 Sep, Zeugswetter Andreas SB SD wrote: > >> > >> > Are those response times in the right unit? 7-10s? >> > >> > No problem: http://developer.osdl.org/markw/misc/plana.out >> >> Ok, I guess I misunderstood you. These queries are taking 0.5ms - 300ms except >> for the last aggregate query which takes just over 1s. > > Yes, but because this is a benchmark he probably has many clients running > in parallel. > > It would be interesting to see the 'explain analyze' from a session that runs > concurrently with the benchmark.
Funny you should mention that, because I generated that 'explain analyze' while I was running the workload. :) Mark ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
