From: Amit Langote [mailto:langote_amit...@lab.ntt.co.jp] > I measured the gain in performance due to each patch on a modest virtual > machine. Details of the measurement and results follow.
Amazing! UPDATE > nparts master 0001 0002 0003 > ====== ====== ==== ==== ==== > 0 2856 2893 2862 2816 > 8 507 1115 1447 1872 SELECT > nparts master 0001 0002 0003 > ====== ====== ==== ==== ==== > 0 2290 2329 2319 2268 > 8 1058 1077 1414 1788 Even a small number of partitions still introduces a not-small overhead (UPDATE:34%, SELECT:22%). Do you think this overhead can be reduced further? What part do you guess would be relevant? This one? > that it is now performed after pruning. However, it doesn't do anything > about the fact that partitions are all still locked in the earlier phase. Regards Takayuki Tsunakawa