Full Stack / JS
PostgreSQL
11 questions
11 questions
Questions
- 01B-tree, GIN and BRIN — which index when?
- 02Why a Seq Scan instead of an Index Scan?
- 03Clustered index — does the PRIMARY KEY order the table?
- 04Nested Loop, Hash Join, Merge Join
- 05VACUUM vs VACUUM FULL
- 06MVCC — what do concurrent transactions see?
- 07Two requests buy the last item — how do you avoid a race?
- 08Triggers — what are they and when should you use them?
- 09pg_dump, pg_dumpall and pg_basebackup
- 10A huge log table — how do you partition it?
- 11VACUUM or VACUUM FULL?Multiple choice