Aleksander Alekseev <aleksan...@timescale.com> writes: > What he proposes is taking the locks in batches.
I have a strong sense of deja vu here. I'm pretty sure I experimented with this idea last year and gave up on it. I don't recall exactly why, but either it didn't show any meaningful performance improvement for me or there was some actual downside (that I'm not remembering right now). This would've been in the leadup to 989596152 and adjacent commits. I took a quick look through the threads cited in those commit messages and didn't find anything about it, but I think the discussion had gotten scattered across more threads. Some digging in the archives could be useful. regards, tom lane