Re: Has gen_random_uuid() gotten much slower in v17?

2024-09-11 Thread Peter Eisentraut
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 18dev

Re: UUID v1 optimizations...

2019-05-25 Thread Peter Eisentraut
ike keys. Btw., it might be nice to rerun your tests with PostgreSQL 12beta1. The btree storage has gotten some improvements. I don't think it's going to fundamentally solve your problem, but it would be useful feedback. -- Peter Eisentraut http://www.2ndQuadrant.com/

Re: Transaction size and Wal2Json

2019-02-07 Thread Peter Eisentraut
It's plausible that some naive coding would run into the limitation that you describe, but a bit of effort can probably solve it. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Trigger overhead/performance and alternatives?

2018-07-07 Thread Peter Eisentraut
? Maybe wal2json will give you a starting point. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services