Heikki Linnakangas wrote:

> I ran two 24h test runs with DBT-2, one with the patch and one without. 
> To get comparable, predictable results, I turned autovacuum off and run 
> a manual vacuum in a loop on the stock-table alone.
> As expected, the steady-state of the stock table is smaller with the 
> patch. But only by ~2%, that's slightly less than I expected.
> But what surprises me is that response times went up a with the patch. I 
> don't know why.

Maybe because of increased contention of ProcArrayLock?  (I assume you
are using that, althought I haven't seen the patch)

Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to