The Ins and Outs of PostgreSQL Default Configuration Tuning (opens in new tab)

If you’re wondering what the optimal settings for a newly installed Postgres database are, here are some simple steps to take to tune it right from the start. Matt Yonkovit discussed them with Charly Batista, Postgres Tech Lead at Percona during the live-streamed meetup. Watch the recording to see how Charly tunes a default installation of Percona Distribution for PostgreSQL 13. Most of the default settings have been defined long, long time ago, where one gigabyte of RAM was very expensive. S...