Tom Lane wrote:
Updated version of Heikki's buffer ring patch, as per my comments here:

The COPY IN part of the patch is not there, pending resolution of
whether we think it adds enough value to be worth uglifying
heap_insert's API for.

I ran a series of tests, and it looks like it's not worth it.

The test case I used was DBT-2, with a big COPY running in the background. That's the same method I used for SELECTs, just replaced the SELECT COUNT(*) with a COPY FROM. The table I copied to was truncated between COPYs, and had no indexes.

The results are inconclusive, because the results seem to be quite inconsistent. With 100 warehouses, and no patch, I'm getting average new-order response times between 1-3 seconds over 5 test runs. The results with the patch are in the same range. Runs with 90 and 120 warehouses also varied greatly.

With the SELECTs, the patch made the big selects to finish quicker, in addition to slightly reducing the impact on other queries. For COPY, that benefit was not there either, and again there was a lot more variance in how long time the COPYs took.

If there's a benefit for COPY from this patch, it's not clear enough to spend effort on. The main problem with COPY seems to be that it causes a very unpredictable impact on other queries. I can post the results if someone wants to look at them, but I couldn't see any clear pattern in them.

  Heikki Linnakangas

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to