Re: Making type Datum be 8 bytes everywhere - Mailing list pgsql-hackers

From Nazir Bilal Yavuz
Subject Re: Making type Datum be 8 bytes everywhere
Date
Msg-id CAN55FZ2_=WgRVrvp0aRzxyLS+Gm9c5L7HrVyXXXmEWo=M8cQbw@mail.gmail.com
Whole thread Raw
In response to Re: Making type Datum be 8 bytes everywhere  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Making type Datum be 8 bytes everywhere
List pgsql-hackers
Hi,

Thank you for working on this!

On Wed, 23 Jul 2025 at 22:00, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> I'm disinclined to put in a huge amount of effort looking for the
> worst case.  We established long ago that we weren't going to
> optimize for 32-bit anymore.  So as long as this doesn't completely
> tank performance on 32-bit, I'm satisfied.  I'd almost say that
> if standard pgbench doesn't notice the change, that's good enough.

I did a basic pgbench benchmark on a 32-bit build and there is no change.

$ pgbench -i -s 100 test
$ pgbench -c 16 -j 16 -b $type -T 150 test

TPS results are:

select-only:
    master:     215654
    patched:    215751

simple-update:
    master:     4454
    patched:    4446

tpcb-like:
    master:     4094
    patched:    4128


-- 
Regards,
Nazir Bilal Yavuz
Microsoft



pgsql-hackers by date:

Previous
From: Bertrand Drouvot
Date:
Subject: Re: Adding wait events statistics
Next
From: Ajin Cherian
Date:
Subject: Re: 024_add_drop_pub.pl might fail due to deadlock