DBA / Database

Что такое Transaction ID Wraparound в PostgreSQL?

What is a transaction and what are transaction isolation levels in PostgreSQL?

What is the difference between checkpointer and background writer?

What PostgreSQL parameters do you know for performance tuning?

Tell me about the main processes of PostgreSQL.

How to identify hanging transactions in PostgreSQL?

What types of backups do you know? What is the difference between them?

What is the difference between logical and physical backup? When should each be used?

What databases are created by default when initializing a PostgreSQL cluster?

What is a replication slot and what is it used for?

What is bloat (swelling) of tables and indexes? How to fight it?

Что такое WAL (Write-Ahead Log)?

What types of replication exist in PostgreSQL? What is the difference between physical and logical replication?

Tell about your resume and professional experience.

What is the difference between VACUUM, VACUUM FULL, and autovacuum?

What is the purpose of statistics in DBMS?

How are WAL segments managed and reused?

What is MVCC (Multi-Version Concurrency Control)?

What is the difference between EXPLAIN and EXPLAIN ANALYZE?

Do you know about the pg_repack extension? How does it help with the VACUUM FULL problem?