4 ms·

I self hosted everything from Postgres to ElasticSearch. IMHO, managed solution ins't that much reliable than running your own with the right planning. Failove

I self hosted everything from Postgres to ElasticSearch. IMHO, managed solution ins't that much reliable than running your own with the right planning. Failover strategy of AWS RDS is just absurb. It's literally just promote other instance, switch DNS over. And I do see issue where the new master are behind a few transaction compare with the replica... Managed database is just to move the responsibility when the database is down to somebody else. Self host gives you a lot of flexibility to mix and experiment with new technologies and tooling.

vira28 5y ago
Amazing. What are some advices that you would give for someone who is looking to self host?
- 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 ago
    Could you elaborate on this or point us to documentation (url, book, ...) about it ?
    - weavie 5y ago
      The 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 ago
        http://pgconfigurator.cybertec.at/ http://pgconfigurator.cybertec.at/ offers a quick way to obtain an often-acceptable tuning.
      - ahachete 5y ago
        We 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.

vira28 5y ago

Amazing. What are some advices that you would give for someone who is looking to self host?

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 ago
  Could you elaborate on this or point us to documentation (url, book, ...) about it ?
  - weavie 5y ago
    The 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 ago
      http://pgconfigurator.cybertec.at/ http://pgconfigurator.cybertec.at/ offers a quick way to obtain an often-acceptable tuning.
    - ahachete 5y ago
      We 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.