10 Things I Hate About PostgreSQL | by Rick Branson | Medium
https://rbranson.medium.com/10-things-i-hate-about-postgresql-20dbab8c2791Create Quick JSON Data Dumps From PostgreSQL | Hashrocket
https://hashrocket.com/blog/posts/create-quick-json-data-dumps-from-postgresqlFully managed PostgreSQL databases | Hacker News
https://news.ycombinator.com/item?id=19162729GitHub - ankane/pgvector: Open-source vector similarity search for Postgres
https://github.com/ankane/pgvectorHacking PostgreSQL
https://www.postgresql.eu/events/pgconfeu2018/sessions/session/2058/slides/96/hackingpg-present.pdfHow 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-postgresqlHow 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-usabilityNotes on some PostgreSQL implementation details
https://buttondown.email/nelhage/archive/22ab771c-25b4-4cd9-b316-31a86f737accOpenAI: Scaling PostgreSQL to the Next Level | PixelsTech
https://www.pixelstech.net/article/1747708863-openai%3a-scaling-postgresql-to-the-next-levelPgvector – vector similarity search for Postgres | Hacker News
https://news.ycombinator.com/item?id=26903105PostgreSQL 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/ef4e4bdc63e68fe3e83c9f98f56af7a4PostgreSQL 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-DETECTEDPostgreSQL: Documentation: 12: E.1. Release 12
https://www.postgresql.org/docs/12/release-12.htmlPostgreSQL: Documentation: 9.3: Pattern Matching
https://www.postgresql.org/docs/9.3/functions-matching.htmlPostgreSQL 11 Reestablishes Window Functions Leadership
https://modern-sql.com/blog/2019-02/postgresql-11Postgres 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=27843084Postgres 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=18855585Things I Hate About PostgreSQL (2020) | Hacker News
https://news.ycombinator.com/item?id=26709019Tuning Debian / Ubuntu for PostgreSQL
https://www.enterprisedb.com/blog/tuning-debian-ubuntu-postgresqlUsing 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.pdfZero Downtime Migrations with ActiveRecord and PostgreSQL
https://tech.lendinghome.com/zero-downtime-migrations-with-activerecord-and-postgresql-b3aca53ffbe6Zero-downtime Postgres migrations - the hard parts - GoCardless Blog
https://gocardless.com/blog/zero-downtime-postgres-migrations-the-hard-partsr/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-collationssql - 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