PostgreSQL: What You Need to Know

A global systems integrator headquartered in Atlanta, Georgia.

• architecture design/assessments
• implementation
• data replication
• professional services for turnkey enterprise management

Your PostgreSQL Team

https://lists.postgresql.org/

https://postgresql.life/

https://postgres-slack.herokuapp.com/

https://t.me/postgreschat

https://discord.gg/tjxNBCz

DBA & Dev Tools

• pgadmin
• DBeaver

Deeper Dives:

• pgbadger (database log analysis)
• pgbench (workload testing)

Architecture

http://www.interdb.jp/pg/pgsql01.html

Architecture

Maintenance: Backups

Logical

pg_dump & pg_restore

Text

Physical

pg_basebackup

Noteworthy Non-Native Backup Tools

pgbarman

BART

Maintenance: Autovacuum

https://xkcd.com/1486/

PostgreSQL Concurrency Control

• Common Question:    

  • “If PostgreSQL stores multiple versions of itself, does that mean I need a LOT more space than another brand of RDBMS?”

    • Short Answer: “No.”

Why Not?