Hello, Thank you for your reply and for creating a new patch.
On Wed, Jun 28, 2023 at 7:58 PM David Rowley <dgrowle...@gmail.com> wrote: > Linux with AMD 3990x, again using the patch from [1] with make installcheck > > master: 1.41720145 seconds > v4: 1.392969606 seconds (1.74% faster than master) > v4 with 0th word check: 1.404199748 seconds (0.93% faster than master) I have tested these versions with installcheck. Since the planning times obtained by installcheck vary each time, it is important to run it repeatedly and examine its distribution. I ran installcheck 100 times for each version. The following tables and the attached figure show the results. From these results, we can conclude that the v4 patch has no regression in the installcheck test. It seems to be slightly (0.31-0.38%) faster than the master. The difference between v4 and v4 with 0th word check is not so clear, but v4 may be faster. Table 1: Total Planning Time During installcheck (seconds) --------------------------------------------------------- | Mean | Median | Stddev --------------------------------------------------------- Master | 2.520865 | 2.521189 | 0.017651 v4 | 2.511447 | 2.513369 | 0.018299 v4 with 0th word check | 2.513393 | 2.515652 | 0.018391 --------------------------------------------------------- Table 2: Speedup (higher is better) ------------------------------------------------------------ | Speedup (Mean) | Speedup (Median) ------------------------------------------------------------ v4 | 0.38% | 0.31% v4 with 0th word check | 0.30% | 0.22% ------------------------------------------------------------ -- Best regards, Yuya Watari