Re: Making empty Bitmapsets always be NULL - Mailing list pgsql-hackers

From Yuya Watari
Subject Re: Making empty Bitmapsets always be NULL
Date
Msg-id CAJ2pMkZGuRtqpbxHD-WEVVrxvQWWSTT+4+RUb68PgYBtbAp4Mg@mail.gmail.com
Whole thread Raw
In response to Re: Making empty Bitmapsets always be NULL  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: Making empty Bitmapsets always be NULL
List pgsql-hackers
Hello,

Thank you for your reply and for creating a new patch.

On Wed, Jun 28, 2023 at 7:58 PM David Rowley <dgrowleyml@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

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Tab completion for CREATE SCHEMAAUTHORIZATION
Next
From: Thomas Munro
Date:
Subject: Re: ReadRecentBuffer() doesn't scale well