Hi Thomas, thank you for your quick reply, much appreciated.
1. "dsa_area could not attach to segment": dsm.c, fixed in commit 6c0fb941. > 2. "cannot unpin a segment that is not pinned": dsm.c, fixed in commit > 0b55aaac. > > Yes, I found both entries in our logs, each once per incident. > The fix will be included in the next set of releases, but in the > meantime you could consider turning off parallel query (set > max_parallel_workers_per_gather = 0). In practice I think you could > also avoid this problem by loading a library that calls something like > srandom(getpid()) in _PG_init() (so it runs in every parallel worker > making ID collisions extremely unlikely), but that's not really a > serious recommendation since it requires writing C code. > > This is very reassuring, as I was slowly starting to doubt my DBA competence here. :) I'll try this workaround until the next release is out, will report if anything out of ordinary re-occurs. Boris
