| From: | David Mullineux <dmullx(at)gmail(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
| Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Has gen_random_uuid() gotten much slower in v17? |
| Date: | 2024-09-11 10:47:41 |
| Message-ID: | CAGsyd8VBW+zwYuLEiJ3JC5NCFveumUiwhJQoS_-zvhnyfARcbQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Good idea. Thanks. I did check. It's not enabled by default but just in
case I did another build. This time explicitly defining --disable-debug and
--disable-cassert. And I tested. Still slower than old versions.
This feels like a build configuration problem. Just can't put my finger on
it yet.
On Wed, 11 Sept 2024, 10:40 Peter Eisentraut, <peter(at)eisentraut(dot)org> wrote:
> On 10.09.24 15:58, David Mullineux wrote:
> > I'm getting a bit concerned by the slow performance of generating uidds
> > on latest dev code versus older versions. Here I compare the time to
> > generate 50k random uuids. Both son the same machine.
> > I must be missing something.
>
> Are you sure that the 18devel installation isn't compiled with
> assertions enabled?
>
> The underlying code for gen_random_uuid() is virtually unchanged between
> PG14 and current.
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcelo Zabani | 2024-09-11 19:11:49 | Re: Partition pruning with array-contains check and current_setting function |
| Previous Message | Peter Eisentraut | 2024-09-11 09:40:16 | Re: Has gen_random_uuid() gotten much slower in v17? |