Dear Ajin, > I compared the patch 1 which does not employ a hash cache and has the > overhead of starting a transaction every time the filter is checked. > > I created a test setup of 10 million inserts in 3 different scenarios: > 1. All inserts on unpublished tables > 2. Half of the inserts on unpublished table and half on pupblished table > 3. All inserts on published tables. > > The percentage improvement in the new optimized patch compared to the > old patch is: > > No transactions in publication: 85.39% improvement > Half transactions in publication: 72.70% improvement > All transactions in publication: 48.47% improvement > > Attaching a graph to show the difference.
I could not find any comparisons with HEAD. Can you clarify the throughput/latency/memory usage with HEAD? Best regards, Hayato Kuroda FUJITSU LIMITED
