Xiaoning Ding wrote: > Postgresql is 7.3.18. [...] > 1 process takes 0.65 second to finish.
> I update PG to 8.2.3. The results are [...] now. > 1 process : 0.94 second You sure about your test environment? Anything else running at the same time, perhaps? I'm a bit surprised that 8.2.3 would be 40% slower than 7.3.18 even in the single process case. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster