Docker – Handling Out of Shared Memory Error in PostgreSQL (container) with Sub Partitioned Table of 36B Rows
I have PostgreSql 15.3 running as a docker container. My docker run configuration is -m 512g --memory-swap 512g --shm-size=16g Using this configuration, I loaded 36B rows, taking up about 30T between tables and indexes. I loaded with about 24 parallel…