PostgreSQL Links

Architecture and Internals and Relational Theory

• PostgreSQL 14 Internals Book by Egor Rogov and Liudmila Mantrova (PostgresPro) https://postgrespro.com/community/books/internals
• Hironobu Suzuki’s PostgreSQL Internals Online Book: http://www.interdb.jp/pg/index.html
• Architecture of a Database System (2007: Joseph Hellerstein, Michael Stonebraker, James Hamilton) https://dsf.berkeley.edu/papers/fntdb07-architecture.pdf
• Readings in Database Systems, 5th Edition (2015: Peter Bailis, Joseph M. Hellerstein, Michael Stonebraker, editors) http://www.redbook.io/
  • Papers mentioned in “Red Book” 5th Edition [DropBox Link]
• What Goes Around Comes Around… And Around… (2024: Michael Stonebraker, Andy Pavlo) https://db.cs.cmu.edu/papers/2024/whatgoesaround-sigmodrec2024.pdf
• Looking Back at Postgres (2019: Joseph Hellerstein) https://arxiv.org/pdf/1901.01973
• John Shepherd’s DBMS Implementation (COMP9315) class materials: https://www.cse.unsw.edu.au/~cs9315/16s1/lectures/
• Noriyoshi Shinoda (from HP Enterprise) PostgreSQL Internals Reference: https://h50146.www5.hpe.com/products/software/oe/linux/mainstream/support/lcc/pdf/PostgreSQL_Internals_1_for_PostgreSQL96_en_20170211-1.pdf
• Hussein Nasser’s YouTube playlist about Database Engineering https://www.youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2

General Training and Education

• Blogs about Postgres: https://planet.postgresql.org/
• Andy Pavlo’s Advanced Database Systems (CMU 15-721) full class materials including videos:  https://15721.courses.cs.cmu.edu/spring2019/
• AWS Free Digital Training – includes a number of PostgreSQL courses https://aws.amazon.com/training/learn-about/databases/
• EnterpriseDB Free Postgres Training (3 full courses) https://www.enterprisedb.com/training
• RedGate Free Postgres Training (8 webinars) https://www.red-gate.com/hub/events/series/postgresql-101
• AWS PostgreSQL In-Depth Training 2019 Ireland (7 videos) https://www.youtube.com/playlist?list=PLhr1KZpdzukeAZuX0pNZ1lLDkaZWBOhQT
• Aaron Francis’ “Mastering Postgres” video course (first two modules are free – intro and data types) https://masteringpostgres.com/

Migration to PostgreSQL

• PostgreSQL Migration Playbook Overview – much of this applies to any PostgreSQL migration: https://aws.amazon.com/blogs/database/the-database-migration-playbook-has-landed/
  • Direct Link to Playbook (Oracle 19c to PostgreSQL 12.4) https://d1.awsstatic.com/whitepapers/Migration/oracle-database-amazon-aurora-postgresql-migration-playbook-12.4.pdf
  • Direct Link to Playbook (Oracle 11g/12c to PostgreSQL 9.6): https://d1.awsstatic.com/whitepapers/Migration/oracle-database-amazon-aurora-postgresql-migration-playbook.pdf
• Amazon DMS Docs for Migrating from Oracle to Aurora PostgreSQL (much of this applies to any migration) https://docs.aws.amazon.com/dms/latest/oracle-to-aurora-postgresql-migration-playbook/chap-oracle-aurora-pg.html
• Amazon DMS Docs for Migrating from SQL Server to PostgreSQL (much of this applies to any migration) https://docs.aws.amazon.com/dms/latest/sql-server-to-aurora-postgresql-migration-playbook/chap-sql-server-aurora-pg.html
• Babelfish: Postgres extension that understands the SQL Server wire-protocol and T-SQL, the Microsoft SQL Server query language, so you don’t have to switch database drivers or re-write all of your application queries https://babelfishpg.org/
• WiltonDB: open source drop-in replacement to Microsoft SQL Server https://wiltondb.com/

Helpful Operational Tools

• Happiness Hints (Postgres best practices): https://ardentperf.com/happiness-hints/
• EXPLAIN PLAN
  • Hubert depesz Lubaczewski’s Explain Plan Formatter: https://explain.depesz.com/
  • Dalibo’s Visual Explain Plan Formatter: https://explain.dalibo.com/
    • Announcement: https://blog.dalibo.com/2019/10/04/pev2.html
• RELEASE NOTES
  • Depesz “Why-Upgrade” tool… summarize & search release notes between any two versions: https://why-upgrade.depesz.com/
  • Bucardo summary of release notes: https://bucardo.org/postgres_all_versions.html
• PARAMETERS
  • https://www.postgresql.org/docs/16/runtime-config.html
  • https://postgresqlco.nf/doc/en/param/
  • https://pgpedia.info/
  • https://pgconfig.rustprooflabs.com/

References

• Main PostgreSQL website: https://www.postgresql.org/
• Documentation: https://www.postgresql.org/docs/current/index.html
  • Documentation Index: https://www.postgresql.org/docs/current/bookindex.html
• Quarterly Update Release Dates: https://www.postgresql.org/developer/roadmap/
  • Policy on Updates and End of Support: https://www.postgresql.org/support/versioning/
  • List of Security Issues, CVSS Scores, Fix Versions: https://www.postgresql.org/support/security/
  • Note about RDS PostgreSQL Release Timelines: https://forums.aws.amazon.com/thread.jspa?threadID=240278
• Josh Berkus’ Parameter (a.k.a. GUC) Annotations/Reference: https://github.com/jberkus/annotated.conf
• Bruce Momjian’s PgLife Summary Page: http://pglife.momjian.us/index.html (this is my browser’s home page <g>)

Source Code and Development

• Official Public PostgreSQL Source: https://git.postgresql.org/gitweb/?p=postgresql.git;a=summary
• Browsable, inter-linked source viewer: https://doxygen.postgresql.org/ (note: GitHub has also now added features to inter-link source)
• Searchable source viewer: https://github.com/postgres/postgres/
• Mailing Lists: https://www.postgresql.org/list/ (esp. general and hackers)

PostgreSQL at Amazon

• RDS PostgreSQL Docs: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html
• Aurora PostgreSQL Docs: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.AuroraPostgreSQL.html
• Public RDS Forum: https://forums.aws.amazon.com/forum.jspa?forumID=60
• Public Aurora Forum: https://forums.aws.amazon.com/forum.jspa?forumID=227
• AWS Database Blog: https://aws.amazon.com/blogs/database/
  • Tag “RDS For PostgreSQL”: https://aws.amazon.com/blogs/database/category/database/amazon-rds/rds-for-postgresql/
  • Tag “Aurora/PostgreSQL-Compatible”: https://aws.amazon.com/blogs/database/category/database/amazon-aurora/postgresql-compatible/
• AWS Workshops
  • Performance Monitoring Workshop for RDS PostgreSQL and Aurora PostgreSQL https://catalog.us-east-1.prod.workshops.aws/workshops/31babd91-aa9a-4415-8ebf-ce0a6556a216/en-US
  • Amazon Aurora Labs for PostgreSQL https://catalog.us-east-1.prod.workshops.aws/workshops/098605dc-8eee-4e84-85e9-c5c6c9e43de2/en-US
  • Troubleshoot Amazon Aurora PostgreSQL Performance by Use Case https://catalog.workshops.aws/apg-perf-troubleshooting/en-US