10 Things I Hate About PostgreSQL | by Rick Branson | Medium
https://rbranson.medium.com/10-things-i-hate-about-postgresql-20dbab8c2791
Create Quick JSON Data Dumps From PostgreSQL | Hashrocket
https://hashrocket.com/blog/posts/create-quick-json-data-dumps-from-postgresql
Fully managed PostgreSQL databases | Hacker News
https://news.ycombinator.com/item?id=19162729
GitHub - ankane/pgvector: Open-source vector similarity search for Postgres
https://github.com/ankane/pgvector
Hacking PostgreSQL
https://www.postgresql.eu/events/pgconfeu2018/sessions/session/2058/slides/96/hackingpg-present.pdf
How to get execution plan for a running query in postgresql? - Stack Overflow
https://stackoverflow.com/questions/45862570/how-to-get-execution-plan-for-a-running-query-in-postgresql
How we upgraded PostgreSQL at GitLab.com | GitLab
https://about.gitlab.com/blog/2020/09/11/gitlab-pg-upgrade/
Lessons Learned from Running Postgres 13: Better Performance, Monitoring & More
https://pganalyze.com/blog/postgres13-better-performance-monitoring-usability
Notes on some PostgreSQL implementation details
https://buttondown.email/nelhage/archive/22ab771c-25b4-4cd9-b316-31a86f737acc
Pgvector – vector similarity search for Postgres | Hacker News
https://news.ycombinator.com/item?id=26903105
PostgreSQL Scalability: Towards Millions TPS - Alexander Korotkov's blog
https://akorotkov.github.io/blog/2016/05/09/scalability-towards-millions-tps/
PostgreSQL collation is a massive footgun
https://gist.github.com/rraval/ef4e4bdc63e68fe3e83c9f98f56af7a4
PostgreSQL fsync Failure Fixed – Minor Versions Released Feb 14, 2019 - Percona Database Performance Blog
https://www.percona.com/blog/2019/02/22/postgresql-fsync-failure-fixed-minor-versions-released-feb-14-2019/#FSYNC-ERRORS-ARE-NOW-DETECTED
PostgreSQL: Documentation: 12: E.1. Release 12
https://www.postgresql.org/docs/12/release-12.html
PostgreSQL: Documentation: 9.3: Pattern Matching
https://www.postgresql.org/docs/9.3/functions-matching.html
PostgreSQL 11 Reestablishes Window Functions Leadership
https://modern-sql.com/blog/2019-02/postgresql-11
Postgres Handles More Than You Think
https://www.infoq.com/articles/postgres-handles-more-than-you-think/
Postgres scaling advice for 2021 - CYBERTEC | PostgreSQL
https://www.cybertec-postgresql.com/en/postgres-scaling-advice-for-2021/
Postgres sequences can skip 32 unexpectedly | Hacker News
https://news.ycombinator.com/item?id=27843084
Postgres tips for Rails developers
https://www.citusdata.com/blog/2017/04/28/postgres-tips-for-rails/
Postgres: Column Change Migrations with Zero Downtime In Rails - Jilt
https://jilt.com/blog/migrations-zero-downtime-rails/
Take a Dip into PostgreSQL Arrays - Compose Articles
https://www.compose.com/articles/take-a-dip-into-postgresql-arrays/
The dangers of streaming across versions of glibc: A cautionary tale (2014) | Hacker News
https://news.ycombinator.com/item?id=18855585
The future of Postgres? - Craig Kerstiens
https://www.craigkerstiens.com/2024/10/18/the-future-of-postgres/
Things I Hate About PostgreSQL (2020) | Hacker News
https://news.ycombinator.com/item?id=26709019
Tuning Debian / Ubuntu for PostgreSQL
https://www.enterprisedb.com/blog/tuning-debian-ubuntu-postgresql
Using Temporary Tables in PostgreSQL with Rails
https://blog.honeybadger.io/using-temporary-tables-in-postgresql-with-rails/
What Goes Around Comes Around
https://15721.courses.cs.cmu.edu/spring2020/papers/01-intro/whatgoesaround-stonebraker.pdf
Zero Downtime Migrations with ActiveRecord and PostgreSQL
https://tech.lendinghome.com/zero-downtime-migrations-with-activerecord-and-postgresql-b3aca53ffbe6
Zero-downtime Postgres migrations - the hard parts - GoCardless Blog
https://gocardless.com/blog/zero-downtime-postgres-migrations-the-hard-parts
r/PostgreSQL - How to add a foreign key constraint without locking both tables
https://www.reddit.com/r/PostgreSQL/comments/40nrp1/how_to_add_a_foreign_key_constraint_without/
sql - Does PostgreSQL support "accent insensitive" collations? - Stack Overflow
https://stackoverflow.com/questions/11005036/does-postgresql-support-accent-insensitive-collations
sql - PostgreSQL wildcard LIKE for any of a list of words - Stack Overflow
https://stackoverflow.com/questions/4928054/postgresql-wildcard-like-for-any-of-a-list-of-words