What is PostgreSQL?
An open-source object-relational database management system
Where did PostgreSQL originate?
The POSTGRES project at the University of California
What year was Postgres95 released?
1994
What was Postgres95 renamed to?
PostgreSQL
How is PostgreSQL commonly pronounced?
Postgres
What industries used early PostgreSQL systems?
Finance, aviation, medicine
What is the LAPP stack?
Linux, Apache, PostgreSQL, PHP
What does open-source mean for PostgreSQL?
Code can be used, modified, and distributed
Why is PostgreSQL called object-relational?
It supports inheritance and overloading
What operating systems support PostgreSQL?
Most modern operating systems
Does PostgreSQL support ANSI SQL?
Yes
Name three relational features of PostgreSQL
Keys, transactions, views
What NoSQL-style features does PostgreSQL support?
JSON and HSTORE
What is PostGIS?
A PostgreSQL extension for spatial data
What is synchronous replication in PostgreSQL?
Changes written to two nodes at the same time
What is asynchronous replication in PostgreSQL?
Changes sent to read-only replicas later
What is the benefit of replication?
High availability and scalability
What happens if the primary node fails?
A replica can be promoted
What is multi-master replication?
Multiple read/write nodes replicating each other
Give an example of PostgreSQL multi-master software
EDB PostgreSQL Replication Server
What is partitioning?
Splitting a table into smaller sections
Why use partitioning?
Improves query performance
What is sharding?
Storing table partitions across multiple servers
What types of data does PostgreSQL support?
Relational, structured, and non-structured
