On Thu, May 27, 2021 at 2:26 PM Amit Kapila <amit.kapil...@gmail.com> wrote: > > I think some other cause of contention on relation extension locks are > > 1. CTAS is using a buffer strategy and due to that, it might need to > > evict out the buffer frequently for getting the new block in. Maybe > > we can identify by turning off the buffer strategy for CTAS and > > increasing the shared buffer so that data fits in memory. > > > > One more thing to ensure is whether all the workers are using the same > access strategy?
In the Parallel Inserts in CTAS patches, the leader and each worker uses its own ring buffer of 16MB i.e. does myState->bistate = GetBulkInsertState(); separately. With Regards, Bharath Rupireddy. EnterpriseDB: http://www.enterprisedb.com
