Hello all, I’m working with @Abdelrahman_MoHamed on this. We recently migrated a site with roughly 500k topics and 3.5 million users to discourse. We are self hosted on GCP. During this process our partner who assisted with the migration mentioned it might make sense to optimize Postgres to get proper performance from the DB. Our assumption was the DB would come optimized for discourse out of the box (maybe it is?). However given their (the partner suggestion) we wanted to follow up here.
Long story short are these some common ways to optimize Postgres for a DB with the numbers posted here?
Thanks in advance for the help!