40 Best PostgreSQL/Aurora Postgres DBA Interview Questions - Part1
Q1. What is write-ahead logging (WAL)? or What are WAL files / segments?
Answer:
Q2. What is vacuuming?
Answer:
Q3. What is a vacuum full?
Answer:
Q4. What are the vacuum related init database parameters?
Answer:
Q5. What is auto vacuuming (or) what is the difference between normal vacuum and auto-vacuum?
Answer:
Q6. What are the auto vacuum related init database parameters?
Answer:
Q7. How you will confirm whether the auto-vacuum is completed or not?
Answer:
Q8. What is vacuum freeze?
Answer:
Q9. What are Transaction ID wraparound failures and how to avoid them?
Answer:
Q10. What is Frozen Transaction ID (or) what is the difference between normal Transaction ID and Frozen Transaction ID?
Answer:
Q11. How to reclaim space in Postgres?
Answer:
Q12. What is Multi-Version Concurrency Control (MVCC) in PostgreSQL?
Answer:
Q13. What are shared buffers (what is the use of shared_buffer parameter)?
Answer:
Q14. Why would Postgres not free up storage space even after the deletion of data?
Answer:
Q15. What is the use of pg_repack extension? How to remove bloating tables/indexes from (Aurora) Postgres databases?
Answer:
Q16. What is a checkpoint? how often checkpoint will happen?
Answer:
Q17. What is bgwriter? how often background writer should invoke?
Answer:
Q18. What are the toast tables?
Answer:
Q19. What is the meaning of table bloating? how to reduce table/index bloating?
Answer:
Q20. What is Host Based Access (HBA) control? How to allow/restrict a few IP ranges to connect to your Postgres database?
Answer:
No comments:
Post a Comment