POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is a database index, and why is it used in relational databases?

How do you create an index on a column in a PostgreSQL table, and why would you do so?

How does an index improve query performance in PostgreSQL?

What maintenance operations might be necessary to keep a PostgreSQL index effective?

How do indexes in PostgreSQL affect write operations such as INSERT, UPDATE, and DELETE?

What is a partial index in PostgreSQL, and when might you use one?

How does PostgreSQL enforce uniqueness with indexes, and what happens if you try to insert a duplicate value?

What is an index scan in PostgreSQL, and how does it differ from a sequential scan?

What is index bloat in PostgreSQL, and how can it affect database performance?

How can you use the `EXPLAIN` command in PostgreSQL to determine if an index is being used in a query?