3 ms·
Amazing. What are some advices that you would give for someone who is looking to self host?
by vira28 5y ago
Amazing. What are some advices that you would give for someone who is looking to self host?
- weavie 5y agoNever 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.
- lkuty 5y agoCould you elaborate on this or point us to documentation (url, book, ...) about it ?
- weavie 5y agoThe postgres docs are excellent, https://www.postgresql.org/docs/13/runtime-config.html 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?
- natmaka 5y agohttp://pgconfigurator.cybertec.at/ http://pgconfigurator.cybertec.at/ offers a quick way to obtain an often-acceptable tuning.
- ahachete 5y agoWe created https://postgresqlco.nf 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.
- reacharavindh 5y ago+1 for spending a little time to tune Postgres for your needs. Also, backup and test restores regularly.