Postgres Administration [TODO]
Database Hosting
- https://aws.amazon.com/free/database/
- https://heliohost.org/
- https://supabase.com/
- https://fly.io/blog/free-postgres/
- https://hasura.io/learn/database/postgresql/installation/5-postgresql-hosting-providers/
References
- Concepts
- https://docs.qgis.org/2.18/en/docs/training_manual/database_concepts/index.html
- https://www.postgresqltutorial.com/
- https://arctype.com/blog/postgresql-features-list/
- http://www.foo.be/docs-free/aw_pgsql_book.pdf
- https://www.codecademy.com/learn/fscp-advanced-postgresql/modules/fscp-postgres-database-performance/cheatsheet
- https://www.educba.com/postgresql-features/
- Bloating
- https://www.cybertec-postgresql.com/en/index-bloat-reduced-in-postgresql-v14/
- https://medium.com/compass-true-north/dealing-with-significant-postgres-database-bloat-what-are-your-options-a6c1814a03a5
- https://www.highgo.ca/2021/03/20/how-to-check-and-resolve-bloat-in-postgresql/
- https://www.highgo.ca/tag/postgresql/
- Connection Management
- https://pgpool.net/mediawiki/index.php/Main_Page
- https://scalegrid.io/blog/postgresql-connection-pooling-part-4-pgbouncer-vs-pgpool/
- https://tommasini-giovanni.medium.com/resilient-postgresql-cluster-pgbouncer-pgpool-ii-and-repmgr-88830de6e8ea
- https://www.cybertec-postgresql.com/en/pgbouncer-types-of-postgresql-connection-pooling/