> > >> > 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. Andreas ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings