From: Tang, Haiying <tanghy.fnst@cn.fujitsu.com>
> (does this patch make some optimizes in serial insert? I'm a little confused
> here, Because the patched execution time is less than unpatched, but I didn't
> find information in commit messages about it. If I missed something, please
> kindly let me know.)
I haven't thought of anything yet. Could you show us the output of EXPLAIN (ANALYZE, BUFFERS, VERBOSE) of 1,000
partitionscase for the patched and unpatched? If it doesn't show any difference, the output of perf may be necessary
next.
(BTW, were all the 1,000 rows stored in the target table?)
> I did another test which made check overhead obvious. this case is not fitting
> for partition purpose, but I put it here as an extreme case too.
> Select table total rows are 1,000, # of partitions is 2000. So only the first 1000
> partitions have 1 row per partition, the last 1000 partitions have no data
> inserted.
Thank you, that's a good test.
Regards
Takayuki Tsunakawa