Training Trains logo

PostgreSQL DBA Internship Interview Questions for Freshers (with Answers)

By K. Boopathikumar, CEO & Founder · 16 November 2026 · 7 min read

PostgreSQL DBA interns help keep databases fast, safe and recoverable. Interviews test PostgreSQL internals at a basic level, query tuning and backup and recovery.

Internals

  • What is MVCC? Multi-version concurrency control: each update creates a new row version, so readers do not block writers.
  • Why is VACUUM needed? To clean up old row versions, reclaim space and prevent transaction ID wraparound. Autovacuum does this automatically when tuned.
  • What is the WAL? The write-ahead log records changes before they reach data files, enabling crash recovery and replication.
  • What are tablespaces and schemas? Tablespaces set where data is stored on disk; schemas group objects logically inside a database.

Performance

  • How do you find a slow query? Use pg_stat_statements to find heavy queries, then EXPLAIN ANALYZE to see the plan.
  • B-tree vs GIN vs BRIN index? B-tree for equality and ranges; GIN for arrays, JSONB and full-text search; BRIN for very large tables with naturally ordered data.
  • Why might an index not be used? Low selectivity, functions on the column, type mismatches or outdated statistics.
  • What is connection pooling? Reusing database connections with a tool such as PgBouncer, because each connection uses memory.

Backup and security

  • pg_dump vs physical backups? pg_dump creates logical backups of databases; physical backups (pg_basebackup) copy files and, with WAL, allow point-in-time recovery.
  • What is streaming replication? A standby server applies WAL from the primary to stay in sync for failover and read scaling.
  • How do you manage access? Roles with least privilege, grants per schema and table, and pg_hba.conf rules for connections.
  • How do you know a backup works? Restore it regularly on another server and check the data.

How to answer well in the interview

  • Show an EXPLAIN plan you improved.
  • Talk about restore tests, not just backups.
  • Know common monitoring views.
  • Practise on Docker PostgreSQL locally.

Next steps

Looking for an internship near Erode?

10 days to 6 months, online or at our Erode and Perundurai branches, with a verifiable certificate.

See internships →

More guides