4 ms·
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 b
by weavie 5y ago
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.
- 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.