Amazing. What are some advices that you would give for someone who is looking to self host?
back
2 comments
Never run postgres with the default configuration. It comes with some extremely conservative settings so you are unlikely to get decent performance out of the box.
Could you elaborate on this or point us to documentation (url, book, ...) about it ?
The postgres docs are excellent, https://www.postgresql.org/docs/13/runtime-config.html
I have seen tutorials where folks go over the most essential settings, but I can't seem to find the ones I have used now, so me just doing a search for 'postgres tuning' is no better than you doing the search yourself.
Maybe someone else can chime in with a good guide?
We created https://postgresqlco.nf which not only offers detailed help about all configuration parameters, but also provides a "repository" for you to upload/download your Postgres configurations, and a Tuning Guide. Hope it helps.
http://pgconfigurator.cybertec.at/ offers a quick way to obtain an often-acceptable tuning.
+1 for spending a little time to tune Postgres for your needs. Also, backup and test restores regularly.