Streaming replication fails after some time with 'incorrect resource manager data checksum'

2019-12-18 Thread Julian Backes
Hello all! I already posted in the slack chat #help channel but got no answer :-( We have a read only / hot standby system and are facing the same problem as described in https://stackoverflow.com/questions/35752389/incorrect-resource-manager-data-checksum-in-record-at-2-xyz-terminating-walrec (t

Re: ERROR: too many dynamic shared memory segments

2020-01-29 Thread Julian Backes
Hi, we only had the "too many shared too many dynamic shared memory segments" error but no segmentation faults. The error started occurring after upgrading from postgres 10 to postgres 12 (server has 24 cores / 48 threads, i.e. many parallel workers). The error itself was not that much of a proble

Re: Sequence vs UUID

2023-02-06 Thread Julian Backes
I don't really understand what you mean by 'performance'. To me it is not surprising that incrementing (I know it is not just incrementing) a 64bit integer is faster than generating 128 bit data with a good amount of random data even if it seems to be too slow. So in my opinion you need to separate