Justin Pryzby <pryzby@xxxxxxxxxxxxx> writes: > As $subject: backends are stuck in startup for minutes at a time. I didn't > strace this time, but I believe last time I saw one was waiting in a futex. Hm... > I saved ~40 cores from backends from the most recent incident, which are all > essentially identical: This one seems to be waiting for a shared LWLock (specifically, one of the locks for the shared-buffer lookup hashtable), which could only block if someone else is holding that lock exclusively, which implies that there's at least one backtrace that's different from this. Unless you can find what was holding that lock, there's not much we can learn from this report ... regards, tom lane
