> For the complete documentation index, see [llms.txt](https://bryan-guner.gitbook.io/knowledge/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://bryan-guner.gitbook.io/knowledge/14-pure-education/knowledge-master/databases/postgresql.md).

# PostgreSQL

## Notes

* [Can use `::1` in Postico to remove unsafe connection warning](https://github.com/jakob/Postico/issues/637)

## Links

* [PostgreSQL Exercises](https://pgexercises.com/)
* [Skor](https://github.com/hasura/skor) - Listen to Postgres events and forward them as JSON payloads to a webhook.
* [PipelineDB](https://github.com/pipelinedb/pipelinedb) - High-performance time-series aggregation for PostgreSQL.
* [pgsync](https://github.com/ankane/pgsync) - Sync Postgres data between databases.
* [Bye bye Mongo, Hello Postgres](https://www.theguardian.com/info/2018/nov/30/bye-bye-mongo-hello-postgres) ([HN](https://news.ycombinator.com/item?id=18717168))
* [The Internals of PostgreSQL](https://www.interdb.jp/pg/) ([HN](https://news.ycombinator.com/item?id=18950460))
* [Slonik](https://github.com/gajus/slonik) - PostgreSQL client with strict types, detail logging and assertions for node.js
* [Postico](https://eggerapps.at/postico/) - Modern PostgreSQL Client for the Mac.
* [prettier-plugin-pg](https://github.com/benjie/prettier-plugin-pg) - Work-in-progress plugin for prettier to support formatting of PostgreSQL-flavour SQL.
* [PostGraphile](https://github.com/graphile/postgraphile) - Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database.
* [WAL-G](https://github.com/wal-g/wal-g) - Archival restoration tool for Postgres.
* [migra](https://github.com/djrobstep/migra) - Like diff but for PostgreSQL schemas.
* [PGHoard](https://github.com/aiven/pghoard) - PostgreSQL backup and restore service.
* [postgresqltuner.pl](https://github.com/jfcoz/postgresqltuner) - Simple script to analyse your PostgreSQL database configuration, and give tuning advice.
* [Common mistakes in PostgreSQL](https://wiki.postgresql.org/wiki/Don%27t_Do_This) ([HN](https://news.ycombinator.com/item?id=19817531))
* [pgx](https://github.com/jackc/pgx) - PostgreSQL driver and toolkit for Go.
* [postgres-operator](https://github.com/CrunchyData/postgres-operator) - Controller that runs within a Kubernetes cluster that provides a means to deploy and manage PostgreSQL clusters.
* [Fastest Way to Load Data Into PostgreSQL Using Python (2019)](https://hakibenita.com/fast-load-data-python-postgresql)
* [pgfutter](https://github.com/lukasmartinelli/pgfutter) - Import CSV and JSON into PostgreSQL the easy way.
* [The Art of PostgreSQL](https://theartofpostgresql.com/) - Book that teaches SQL to developers: Learn to replace thousands of lines of code with simple queries. ([Lobsters](https://lobste.rs/s/yvhv9r/art_postgresql))
* [PLV8](https://github.com/plv8/plv8) - V8 Engine Javascript Procedural Language add-on for PostgreSQL.
* [HN: PostgreSQL 12 release (2019)](https://news.ycombinator.com/item?id=21146356)
* [PostgreSQL: When it’s not your job (2017)](https://thebuild.com/presentations/not-your-job-pgconf-us-2017.pdf)
* [Postgres Is Underrated—It Handles More than You Think (2019)](https://dev.to/heroku/postgres-is-underrated-it-handles-more-than-you-think-4ff3) ([Lobsters](https://lobste.rs/s/oqb6fu/postgres_is_underrated_it_handles_more))
* [Postgres Schema Design](https://www.graphile.org/postgraphile/postgresql-schema-design/) ([HN](https://news.ycombinator.com/item?id=22718466))
* [PostgreSQL for Beginners book](https://postgrespro.com/education/books/introbook) - Intended for those who only start getting acquainted with the world of PostgreSQL.
* [PostgreSQL Notes](https://github.com/poudel/notes/blob/master/notes/postgresql.org)
* [pg\_flame](https://github.com/mgartner/pg_flame) - Flamegraph generator for Postgres EXPLAIN ANALYZE output.
* [PostgREST](https://github.com/PostgREST/postgrest) - Serves a fully RESTful API from any existing PostgreSQL database. ([HN](https://news.ycombinator.com/item?id=21435195)) ([HN 2](https://news.ycombinator.com/item?id=25159097)) ([Introduction to Postgrest](https://samkhawase.com/blog/postgrest/postgrest_introduction/))
* [Postgres Explain Visualizer (pev)](https://github.com/AlexTatiyants/pev)
* [Dexter](https://github.com/ankane/dexter) - Automatic indexer for Postgres.
* [Hypothetical Indexes in PostgreSQL (2019)](https://www.percona.com/blog/2019/06/21/hypothetical-indexes-in-postgresql/)
* [System design hack: Postgres is a great pub/sub & job server (2019)](https://layerci.com/blog/postgres-is-the-answer/) ([HN](https://news.ycombinator.com/item?id=21484215))
* [Turning PostgreSQL into a queue serving 10,000 jobs per second](https://gist.github.com/chanks/7585810) ([HN](https://news.ycombinator.com/item?id=21536698))
* [PGLoader](https://github.com/dimitri/pgloader) - Migrate to PostgreSQL in a single command. ([HN](https://news.ycombinator.com/item?id=21628094)) ([Web](https://pgloader.io/))
* [PgHero](https://github.com/ankane/pghero) - Performance dashboard for Postgres.
* [pg-structure](https://github.com/ozum/pg-structure) - Get PostgreSQL database structure as a detailed JS Object.
* [Odyssey](https://github.com/yandex/odyssey) - Advanced multi-threaded PostgreSQL connection pooler and request router.
* [PostgreSQL at low level: stay curious! (2019)](https://erthalion.info/2019/12/06/postgresql-stay-curious/)
* [pgAudit](https://github.com/pgaudit/pgaudit) - PostgreSQL Audit Extension.
* [Message DB: Event Store and Message Store for PostgreSQL (2019)](https://blog.eventide-project.org/articles/announcing-message-db/) ([HN](https://news.ycombinator.com/item?id=21810272)) ([Code](https://github.com/message-db/message-db))
* [Supabase Realtime](https://github.com/supabase/realtime) - Listens to changes in a PostgreSQL Database and broadcasts them over websockets.
* [py-pgproto](https://github.com/MagicStack/py-pgproto) - Low-level IO utilities for PosgtreSQL drivers.
* [pgweb](https://github.com/sosedoff/pgweb) - Cross-platform client for PostgreSQL databases.
* [plow](https://github.com/andywer/plow) - Postgres migrations and seeding made easy.
* [New Plan](https://explain.dalibo.com/) - Analyze, visualize and share Postgres Query Plans.
* [New Explain](https://explain.depesz.com/) - PostgreSQL's explain analyze made readable.
* [postgresql.conf](https://postgresqlco.nf/en/doc/param/) - Postgres configuration reference. Helps tune and optimize PostgreSQL configuration.
* [My GOTO Postgres Configuration for Web Services (2020)](https://tightlycoupled.io/my-goto-postgres-configuration-for-web-services/)
* [pg\_timetable](https://github.com/cybertec-postgresql/pg_timetable) - Advanced scheduling for PostgreSQL. ([Article](https://www.cybertec-postgresql.com/en/pg_timetable-advanced-postgresql-job-scheduling/))
* [PostgreSQL at Scale: Database Schema Changes Without Downtime (2019)](https://medium.com/braintree-product-technology/postgresql-at-scale-database-schema-changes-without-downtime-20d3749ed680)
* [Strong migrations](https://github.com/ankane/strong_migrations) - Catch unsafe migrations in development.
* [PostgreSQL Documentation](https://www.postgresql.org/docs/12/index.html)
* [HN: The state of full text search in PostgreSQL 12 (2020)](https://news.ycombinator.com/item?id=22223629)
* [pgmetrics](https://github.com/rapidloop/pgmetrics) - Collect and display information and stats from a running PostgreSQL server. ([Web](https://pgmetrics.io/))
* [pgDash](https://pgdash.io/) - Comprehensive diagnostic and monitoring solution designed to help you ensure the ongoing health and performance of your PostgreSQL deployment.
* [pgcli](https://github.com/dbcli/pgcli) - Postgres CLI with autocompletion and syntax highlighting.
* [Transactionally Staged Job Drains in Postgres (2017)](https://brandur.org/job-drain) ([HN](https://news.ycombinator.com/item?id=15294722))
* [Postgres source code](https://github.com/postgres/postgres)
* [Postgres Explain Visualizer (pev)](https://dalibo.github.io/pev2/#/) - VueJS component to show a graphical visualization of a PostgreSQL execution plan. ([Code](https://github.com/dalibo/pev2)) ([HN](https://news.ycombinator.com/item?id=22472175))
* [Awesome Postgres](https://github.com/dhamaniasad/awesome-postgres)
* [PostgreSQL Automatic Failover](https://github.com/ClusterLabs/PAF) - High-Availibility for Postgres, based on industry references Pacemaker and Corosync.
* [pgagroal](https://github.com/agroal/pgagroal) - High-performance protocol-native connection pool for PostgreSQL.
* [Distinct On: The Confusing, Unique and Useful Feature in Postgres (2020)](https://www.yogeshchauhan.com/167/postgres/the-confusing-unique-and-useful-feature-in-postgres-distinct-on) ([HN](https://news.ycombinator.com/item?id=22625642))
* [Simplify: move code into database functions](https://sivers.org/pg)
* [Postgres Weekly](https://postgresweekly.com/) - Free, once–weekly e-mail round-up of PostgreSQL news and articles.
* [graphile-migrate](https://github.com/graphile/migrate) - Opinionated SQL-powered productive roll-forward migration tool for PostgreSQL.
* [pgslice](https://github.com/ankane/pgslice) - Postgres partitioning as easy as pie.
* [Things I Hate About PostgreSQL (2020)](https://medium.com/@rbranson/10-things-i-hate-about-postgresql-20dbab8c2791) ([HN](https://news.ycombinator.com/item?id=22775330)) ([Lobsters](https://lobste.rs/s/j2ptta/10_things_i_hate_about_postgresql))
* [pgFormatter](http://sqlformat.darold.net/) - PostgreSQL SQL syntax beautifier. ([Code](https://github.com/darold/pgFormatter))
* [graphile-worker](https://github.com/graphile/worker) - Job queue for PostgreSQL running on Node.js.
* [pgBadger](http://pgbadger.darold.net/) - PostgreSQL log analyzer built for speed with fully detailed reports and professional rendering. ([Code](https://github.com/darold/pgbadger))
* [pgCluu](http://pgcluu.darold.net/) - PostgreSQL performances monitoring and auditing tool. ([Code](https://github.com/darold/pgcluu))
* [ZomboDB](https://github.com/zombodb/zombodb) - Brings powerful text-search and analytics features to Postgres by using Elasticsearch as an index type.
* [Full Text Search in Milliseconds with Rails and PostgreSQL](https://pganalyze.com/blog/full-text-search-ruby-rails-postgres)
* [Using PostgreSQL for JSON Storage](https://info.crunchydata.com/blog/using-postgresql-for-json-storage) ([HN](https://news.ycombinator.com/item?id=23032889))
* [PGSync](https://github.com/toluaina/pg-sync) - PostgreSQL to Elasticsearch sync.
* [Improved (auto)vacuum in PostgreSQL 13 (2020)](https://amitkapila16.blogspot.com/2020/05/improved-autovacuum-in-postgresql-13.html) ([HN](https://news.ycombinator.com/item?id=23149920))
* [HN: Ask HN: What PostgreSQL client do you use? (2020)](https://news.ycombinator.com/item?id=23208181)
* [Recursive SQL Queries with PostgreSQL (2020)](https://towardsdatascience.com/recursive-sql-queries-with-postgresql-87e2a453f1b)
* [How one word in PostgreSQL unlocked a 9x performance improvement (2020)](https://jlongster.com/how-one-word-postgresql-performance) ([HN](https://news.ycombinator.com/item?id=23516947))
* [pgCenter](https://github.com/lesovsky/pgcenter) - Command-line admin tool for observing and troubleshooting Postgres.
* [Supabase](https://supabase.io/) - Adds realtime and restful APIs to Postgres without a single line of code. (\[[HN](https://news.ycombinator.com/item?id=23319901)]) ([Code](https://github.com/supabase/postgres)) ([Docs](https://github.com/supabase/supabase)) ([JS client](https://github.com/supabase/supabase-js)) ([CLI](https://github.com/supabase/cli))
* [Queries to monitor your PostgreSQL database](https://github.com/nilenso/postgresql-monitoring)
* [PostgreSQL BRIN Indexes: Big Data Performance With Minimal Storage (2019)](https://info.crunchydata.com/blog/postgresql-brin-indexes-big-data-performance-with-minimal-storage)
* [PostgreSQL query parallelism can be like a box of chocolates (2020)](https://swarm64.com/post/increase-postgresql-parallelism/)
* [Swarm64](https://swarm64.com/) - Faster PostgreSQL performance and easier scaling.
* [Patroni](https://github.com/zalando/patroni) - Template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes.
* [PostgreSQL HTTP Client](https://github.com/pramsey/pgsql-http) - Retrieve a web page from inside the database.
* [Crunchy Data](https://www.crunchydata.com/) - Trusted Open Source PostgreSQL & Commercial Support for the Enterprise.
* [Kanel](https://github.com/kristiandupont/kanel) - Generate Typescript types from Postgres.
* [5 Ways to Host PostgreSQL Databases (2020)](https://www.prisma.io/blog/ways-to-host-postgresql-w0xrhqqgp4zp)
* [Jepsen: PostgreSQL 12.3 (2020)](http://jepsen.io/analyses/postgresql-12.3) ([HN](https://news.ycombinator.com/item?id=23498781))
* [pgsodium](https://github.com/michelp/pgsodium) - Modern cryptography for PostgreSQL using libsodium. ([HN](https://news.ycombinator.com/item?id=23476248))
* [Serializable Snapshot Isolation in PostgreSQL](https://drkp.net/papers/ssi-vldb12.pdf)
* [How does MVCC (Multi-Version Concurrency Control) work (2020)](https://vladmihalcea.com/how-does-mvcc-multi-version-concurrency-control-work/)
* [Looking Back at Postgres (2019)](https://arxiv.org/abs/1901.01973) ([HN](https://news.ycombinator.com/item?id=23529954)) ([Notes](https://brandur.org/nanoglyphs/013-remote))
* [The Postgres and Illustra Codelines](https://dl.acm.org/doi/pdf/10.1145/3226595.3226623)
* [Don't Do This - PostgreSQL wiki](https://wiki.postgresql.org/wiki/Don%27t_Do_This)
* [Citus](https://github.com/citusdata/citus) - Distributed PostgreSQL extension for multi-tenant and real-time analytics workloads. ([Web](https://www.citusdata.com/)) ([GitHub](https://github.com/citusdata))
* [Postgres...as an App? (2020)](https://bytes.yingw787.com/posts/2020/06/15/postgres_as_app_1/) ([Lobsters](https://lobste.rs/s/ir2uyk/postgres_as_app))
* [PostgreSQL query JIT (2020)](https://solovyov.net/blog/2020/postgresql-query-jit/)
* [PgBouncer](https://www.pgbouncer.org/) - Lightweight connection pooler for PostgreSQL. ([Code](https://github.com/pgbouncer/pgbouncer))
* [Indexing JSONB columns in PostgreSQL (2020)](https://vsevolod.net/postgresql-jsonb-index/) ([Lobsters](https://lobste.rs/s/if87cc/how_not_use_jsonb_fields_their_indexes))
* [Splitgraph](https://www.splitgraph.com/) - Build and share data with Postgres, inspired by Docker/Git. ([HN](https://news.ycombinator.com/item?id=23627066))
* [Running Postgres in Kubernetes](https://static.sched.com/hosted_files/ossna2020/fc/Running%20Postgres-as-a-Service%20in%20Kubernetes.pdf) ([HN](https://news.ycombinator.com/item?id=23682450))
* [Zero dependancy Pub / Sub system with PostgreSQL (2018)](https://gdelgado.ca/zero-dependancy-pub-sub-system-with-postgresql.html#title)
* [Ephemeral PostgreSQL](https://github.com/eradman/ephemeralpg) - Quickly spin up a temporary PostgreSQL test databases. ([Docs](http://eradman.com/ephemeralpg/))
* [Managing PostgreSQL Logical Replication (2020)](http://eradman.com/posts/pubsub-pgoutput.html)
* [Noisia](https://github.com/lesovsky/noisia) - Harmful workload generator for PostgreSQL.
* [Foreign data wrappers: PostgreSQL's secret weapon? (2020)](https://www.splitgraph.com/blog/foreign-data-wrappers) ([HN](https://news.ycombinator.com/item?id=23769420))
* [PostgreSQL Templates (2020)](https://supabase.io/blog/2020/07/09/postgresql-templates/) ([HN](https://news.ycombinator.com/item?id=23781786))
* [pgx](https://github.com/zombodb/pgx) - Build Postgres Extensions with Rust. ([HN](https://news.ycombinator.com/item?id=23821112))
* [PostgreSQL EXPLAIN glossary](https://www.pgmustard.com/docs/explain)
* [Postgres Job Queues & Failure By MVCC (2020)](https://brandur.org/postgres-queues)
* [PostgreSQL beginner guide (2020)](https://knowledgepill.it/posts/postgresql-basics-guide/) ([HN](https://news.ycombinator.com/item?id=24036132))
* [pgxtesting](https://github.com/go-pa/pgxtesting) - Utilities for having a temporary database per test.
* [PostgreSQL: bloat, pg\_repack, and deferred constraints (2020)](https://medium.com/miro-engineering/postgresql-bloat-pg-repack-and-deferred-constraints-d0ecf33337ec)
* [How we used Postgres extended statistics to achieve a 3000x speedup (2020)](https://build.affinity.co/how-we-used-postgres-extended-statistics-to-achieve-a-3000x-speedup-ea93d3dcdc61)
* [Postgres Execution Plans - Field Glossary (2019)](https://www.pgmustard.com/blog/2019/9/17/postgres-execution-plans-field-glossary)
* [Recursive queries in PostgreSQL (2020)](https://www.cybertec-postgresql.com/en/recursive-queries-postgresql/) ([HN](https://news.ycombinator.com/item?id=24184070))
* [Cloud-Native PostgreSQL on Kubernetes (2020)](https://www.youtube.com/watch?v=MTyY_qjOpXA) ([Slides](https://speakerdeck.com/ongres/stackgres-cloud-native-postgresql-on-kubernetes))
* [Quickly debugging Postgres problems (2020)](https://klotzandrew.com/blog/quickly-debugging-postgres-problems)
* [pg-jump](https://github.com/twooster/pg-jump) - Postgres jumphost with query audit-logging.
* [WAL-E](https://github.com/wal-e/wal-e) - Continuous Archiving for Postgres.
* [Postgres Tips And Tricks](https://pgdash.io/blog/postgres-tips-and-tricks.html)
* [Bootstraping Postgres in your project (2020)](https://manzanit0.github.io/automation/2020/08/26/bootstraping-postgres-greenfield.html)
* [How to use PostgreSQL's LISTEN/NOTIFY as a simple message queue with psycopg2 and asyncio](https://gist.github.com/kissgyorgy/beccba1291de962702ea9c237a900c79)
* [PostgreSQL B-Tree index deduplication (2020)](https://blog.rustprooflabs.com/2020/09/postgres-beta3-btree-dedup) ([HN](https://news.ycombinator.com/item?id=24395825))
* [PostgreSQL and Machine Learning (2020)](https://mljar.com/blog/postgresql-machine-learning/)
* [Things we learned running Postgres 13 (2020)](https://pganalyze.com/blog/postgres13-better-performance-monitoring-usability) ([HN](https://news.ycombinator.com/item?id=24544881))
* [2ndQuadrant](https://www.2ndquadrant.com/en/) - PostgreSQL support company.
* [Mastering PostgreSQL Administration (2020)](https://momjian.us/main/writings/pgsql/administration.pdf) ([HN](https://news.ycombinator.com/item?id=24606163))
* [Cost savings of using managed PostgreSQL](https://news.ycombinator.com/item?id=24608538)
* [How to Fix PostgreSQL Performance Issues with PG Extras (2020)](https://pawelurbanek.com/postgresql-fix-performance)
* [7 Tips for PostgreSQL Bulk Data Loading (2020)](https://www.2ndquadrant.com/en/blog/7-best-practice-tips-for-postgresql-bulk-data-loading/)
* [Zheap: Reinvented PostgreSQL storage (2020)](https://www.cybertec-postgresql.com/en/zheap-reinvented-postgresql-storage/) ([Lobsters](https://lobste.rs/s/qyd3pz/zheap_reinvented_postgresql_storage)) ([HN](https://news.ycombinator.com/item?id=24757333))
* [EDB](https://www.enterprisedb.com/) - Supercharges PostgreSQL.
* [PostgreSQL community impact of 2nd Quadrant purchase (2020)](https://momjian.us/main/blogs/pgblog/2020.html#October_7_2020) ([HN](https://news.ycombinator.com/item?id=24710759))
* [PostgreSQL Contributors](https://www.postgresql.org/community/contributors/)
* [Measuring the Memory Overhead of a Postgres Connection (2020)](https://blog.anarazel.de/2020/10/07/measuring-the-memory-overhead-of-a-postgres-connection/) ([HN](https://news.ycombinator.com/item?id=24735012))
* [prostgles-server](https://github.com/prostgles/prostgles-server-js) - Isomorphic PostgreSQL client for node. ([Web](https://prostgles.com/))
* [pg\_squeeze: Optimizing PostgreSQL storage (2020)](https://www.cybertec-postgresql.com/en/pg_squeeze-optimizing-postgresql-storage/)
* [CYBERTEC PostgreSQL](https://github.com/cybertec-postgresql) - Professional PostgreSQL services. ([Web](https://www.cybertec-postgresql.com/en/))
* [Efficient Evenly Distributed Sampling of Time Series Records in PostgreSQL (2020)](https://blog.joshsoftware.com/2020/10/14/efficient-evenly-distributed-sampling-of-time-series-records-in-postgresql/)
* [postgres-interval](https://github.com/bendrucker/postgres-interval) - Parse Postgres interval columns.
* [The Surprising Impact of Medium-Size Texts on PostgreSQL Performance (2020)](https://hakibenita.com/sql-medium-text-performance)
* [Run PostgreSQL by hands (2019)](https://corpix.dev/2019/02/run-postgresql-by-hands.html)
* [PostgreSQL Monitoring for Application Developers (2020)](https://info.crunchydata.com/blog/postgresql-monitoring-for-application-developers-dba-stats)
* [PostgreSQL Feature Matrix](https://www.postgresql.org/about/featurematrix/)
* [Recurring Events and PostgreSQL (2020)](https://thoughtbot.com/blog/recurring-events-and-postgresql)
* [What's so exciting about Postgres? With Craig Kerstiens (2020)](https://changelog.com/podcast/417) ([HN](https://news.ycombinator.com/item?id=24944852))
* [Building a recommendation engine inside Postgres with Python and Pandas (2020)](https://info.crunchydata.com/blog/recommendation_engine_in_postgres_with_pandas_and_python)
* [Protocol Buffer extension for PostgreSQL](https://github.com/mpartel/postgres-protobuf)
* [Getting Started With Postgres 13 on Ubuntu 20.04 (2020)](https://pgdash.io/blog/postgres-13-getting-started.html?h)
* [prettier-plugin-pg](https://github.com/benjie/prettier-plugin-pg) - Plugin for prettier to support formatting of PostgreSQL-flavour SQL.
* [PGTune](https://pgtune.leopard.in.ua/#/) - Tuning PostgreSQL config by your hardware. ([Code](https://github.com/le0pard/pgtune))
* [Book about PostgreSQL: tuning and scaling (Russian)](https://postgresql.leopard.in.ua/) ([Code](https://github.com/le0pard/postgresql_book))
* [An Immutable Blog Application in PostgreSQL (2015)](https://kevinmahoney.co.uk/articles/immutable-data/) ([Lobsters](https://lobste.rs/s/0owjgi/immutable_blog_application_postgresql))
* [Postgres Constraints (2020)](https://www.mohitkhare.com/blog/postgres-constraints/)
* [Distributed Coordination Using Postgres (2020)](https://ffhex.xyz/posts/distributed-coordination-using-postgres/)
* [pg\_auto\_failover](https://github.com/citusdata/pg_auto_failover) - Postgres extension and service for automated failover and high-availability.
* [Postgres Observability](https://pgstats.dev/) - Postgres views and functions that contain info you might want to know about a Postgres instance. ([HN](https://news.ycombinator.com/item?id=25058045))
* [PostgreSQL Server Exporter](https://github.com/wrouesnel/postgres_exporter) - Prometheus exporter for PostgreSQL server metrics.
* [How to Analyze a PostgreSQL Crash Dump File (2020)](https://www.highgo.ca/2020/11/07/how-to-analyze-a-postgresql-crash-dump-file/)
* [PostgreSQL psql command line tutorial and cheat sheet](https://tomcam.github.io/postgres/) ([HN](https://news.ycombinator.com/item?id=25113440))
* [Viva the NoSQL Postgres - Alexande Korotkov (2019)](https://www.youtube.com/watch?v=70dBszaO67A)
* [The Basics of Views and Materialized Views in PostgreSQL](https://supabase.io/blog/2020/11/18/postgresql-views/)
* [Writing a Postgres Foreign Data Wrapper for Clickhouse in Go (2020)](https://arunsori.me/posts/postgres-clickhouse-fdw-in-go/) ([HN](https://news.ycombinator.com/item?id=25153782))
* [RUM access method](https://github.com/postgrespro/rum) - Provides access method to work with RUM index. It is based on the GIN access methods code. Can be used for full text search.
* [Hypershield](https://github.com/ankane/hypershield) - Shield sensitive data in Postgres and MySQL.
* [PostgreSQL to PostgreSQL in minutes](https://www.stitchdata.com/integrations/postgresql/postgresql/) - Stitch PostgreSQL integration enables you to ETL data from one PostgreSQL database to another PostgreSQL you'd like to use as a data warehouse.
* [Serverless-postgres](https://github.com/MatteoGioioso/serverless-pg) - Package for managing PostgreSQL connections at serverless scale.
* [pg-shortkey](https://github.com/turbo/pg-shortkey) - YouTube-like Short IDs as Postgres Primary Keys. ([HN](https://news.ycombinator.com/item?id=25288188))
* [pg-mem](https://github.com/oguimbal/pg-mem) - Experimental in-memory emulation of a postgres database. Useful for unit tests.
* [pg-listen](https://github.com/andywer/pg-listen) - Postgres LISTEN & NOTIFY that works.
* [pgtricks](https://github.com/akaihola/pgtricks) - Handy helpers for PostgreSQL users.
* [PGCon 2020](https://www.youtube.com/playlist?list=PLuJmmKtsV1dP8IGGH6Z_sYQKxfDqtoSLj) ([HN](https://news.ycombinator.com/item?id=25397088))
* [Mastering Postgres indexes in 10 minutes (2020)](https://fabien.herfray.org/posts/mastering-postgres-indexes-in-10-minutes/)
* [pgreplay-go](https://github.com/gocardless/pgreplay-go) - Postgres load testing tool.
* [pg\_stat\_monitor](https://github.com/percona/pg_stat_monitor) - PostgreSQL Statistics Collector.
* [hasql-queue](https://github.com/jfischoff/hasql-queue) - Module that utilizes PostgreSQL to implement a durable queue for efficently processing payloads. ([Introducing hasql-queue](http://jfischoff.github.io/blog/introducing-hasql-queue.html))
* [tmp-postgres](https://github.com/jfischoff/tmp-postgres) - Create temporary postgres instances. ([Keeping Database Tests Fast with `tmp-postgres`](http://jfischoff.github.io/blog/keeping-database-tests-fast.html)) ([Faster Database Testing with the New `tmp-postgres`](http://jfischoff.github.io/blog/faster-database-testing.html))
* [DbSchema](https://github.com/db-schema/core) - Opinionated database schema management tool that lets you maintain your DB schema with a single ruby file.
* [Apache AGE](https://github.com/bitnine-oss/AgensGraph-Extension) - Graph database extension for PostgreSQL.
* [Bucardo.org](https://bucardo.org/) - PostgreSQL tools for Replication, Monitoring, and Productivity.
* [Re-Introducing Hash Indexes in PostgreSQL (2021)](https://hakibenita.com/postgresql-hash-index)
* [postgresql-hll](https://github.com/citusdata/postgresql-hll) - PostgreSQL extension adding HyperLogLog data structures as a native data type.
* [pg\_cron](https://github.com/citusdata/pg_cron) - Run periodic jobs in PostgreSQL.
* [temBoard](https://github.com/dalibo/temboard) - PostgreSQL Remote Control. ([Web](https://temboard.io/))
* [Postgres Guide](http://postgresguide.com/) ([Code](https://github.com/craigkerstiens/postgresguide.com))
* [Postgres Book Collection](https://github.com/faisalbasra/postgres_books)
* [Embedded Postgres Binaries](https://github.com/zonkyio/embedded-postgres-binaries) - Lightweight bundles of PostgreSQL binaries with reduced size intended for testing purposes.
* [pg\_activity](https://github.com/dalibo/pg_activity) - Command line tool for PostgreSQL server activity monitoring.
* [Our Journey to PostgreSQL 12 (2021)](https://tech.coffeemeetsbagel.com/our-journey-to-postgresql-12-3d6ee15d305a) ([HN](https://news.ycombinator.com/item?id=25910277))
* [Postgres Scaling Advice for 2021](https://www.cybertec-postgresql.com/en/postgres-scaling-advice-for-2021/) ([HN](https://news.ycombinator.com/item?id=25915023))
* [Deploy PostgreSQL With TLS in Kubernetes (2021)](https://info.crunchydata.com/blog/set-up-tls-for-postgresql-in-kubernetes)
* [The Image of Postgres (2021)](https://blog.jonudell.net/2021/01/24/the-image-of-postgres/)
* [Avoiding, Identifying, and dealing with PostgreSQL database corruption (2021)](https://www.highgo.ca/2021/01/27/avoiding-identifying-and-dealing-with-postgresql-database-corruption-part-1/)
* [Planet PostgreSQL](https://planet.postgresql.org/) - Aggregator for Postgres blog posts from across the web.
* [pllua](https://github.com/RhodiumToad/pllua-ng) - Embeds Lua into PostgreSQL as a procedural language module.
* [An unexpected find that freed 20GB of unused index space in PostgreSQL (2021)](https://hakibenita.com/postgresql-unused-index-size) ([HN](https://news.ycombinator.com/item?id=25988871))
* [Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses (2021)](https://www.depesz.com/2021/02/04/waiting-for-postgresql-14-search-and-cycle-clauses/) ([HN](https://news.ycombinator.com/item?id=26024719))
* [PostgreSQL: What is a checkpoint? (2021)](https://www.cybertec-postgresql.com/en/postgresql-what-is-a-checkpoint/)
* [Cleaning Up Your Postgres Database (2021)](https://info.crunchydata.com/blog/cleaning-up-your-postgres-database)
* [Deep PostgreSQL Thoughts: The Linux Assassin (2021)](https://info.crunchydata.com/blog/deep-postgresql-thoughts-the-linux-assassin)
* [pg-boss](https://github.com/timgit/pg-boss) - Queueing jobs in Node.js using PostgreSQL like a boss.
* [FlameExplain](https://flame-explain.com/visualize/input) - PostgreSQL EXPLAIN ANALYZE visualizer with advanced quirk correction algorithms. ([Code](https://github.com/felixge/flame-explain))
* [AWS Babelfish: The Elephant in the PostgreSQL Room? (2021)](https://postgresql.fund/blog/babelfish-the-elephant-in-the-room/) ([HN](https://news.ycombinator.com/item?id=26114281))
* [Metagration](https://github.com/michelp/metagration) - PostgreSQL Migrator in PostgreSQL.
* [Aquameta](https://github.com/aquametalabs/aquameta) - Web development platform built entirely in PostgreSQL.
* [Deep PostgreSQL Thoughts: Resistance to Containers is Futile (2021)](https://info.crunchydata.com/blog/deep-postgresql-thoughts-resistance-to-containers-is-futile)
* [Postgres Trigram search learnings (2021)](https://devlog.hexops.com/2021/postgres-trigram-search-learnings)
* [Postgres regex search over 10,000 GitHub repositories (using only a Macbook) (2021)](https://devlog.hexops.com/2021/postgres-regex-search-over-10000-github-repositories)
* [JIT-Compiling SQL Queries in PostgreSQL Using LLVM (2017)](https://www.pgcon.org/2017/schedule/events/1092.en.html) ([HN](https://news.ycombinator.com/item?id=26211895))
* [Faster data migrations in Postgres (2021)](https://www.citusdata.com/blog/2021/02/20/faster-data-migrations-in-postgres/)
* [Fuzzy Name Matching in Postgres (2021)](https://info.crunchydata.com/blog/fuzzy-name-matching-in-postgresql)