Re: Has gen_random_uuid() gotten much slower in v17?
| От | David Mullineux |
|---|---|
| Тема | Re: Has gen_random_uuid() gotten much slower in v17? |
| Дата | |
| Msg-id | CAGsyd8VBW+zwYuLEiJ3JC5NCFveumUiwhJQoS_-zvhnyfARcbQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Has gen_random_uuid() gotten much slower in v17? (Peter Eisentraut <peter@eisentraut.org>) |
| Ответы |
Re: Has gen_random_uuid() gotten much slower in v17?
|
| Список | 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@eisentraut.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.
В списке pgsql-performance по дате отправления: