From: Amit Langote [mailto:Langote_Amit_f8@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
overheadcan 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