This is a great start, but I’d recommend three more improvements: - Follow this guide to disable all durability settings. We don’t care if the DB can recover f

This is a great start, but I’d recommend three more improvements: - Follow this guide to disable all durability settings. We don’t care if the DB can recover from a crash, since it’s only test data: https://www.postgresql.org/docs/current/non-durability.html https://www.postgresql.org/docs/current/non-durability.html (I wouldn’t worry about unclogged tables, personally) - Set wal_level=minimal, which requires max_wal_senders=0. This reduces the amount of data written to [mem]disk in the first place. - The big one: create a volume in /var/run/postgresql/ and share it with your application so that you can connect over the Unix domain socket rather than TCP. This is substantially faster, especially when you create new connections per test (or per thread).