💻 Computer Science & IT

PostgreSQL in practice

EXPLAIN, index types, MVCC and connection pooling — what you need when the database is the bottleneck.

8questions

harddifficulty

+16max XP (1st try)

not rated yet

Question 1 of 8

`EXPLAIN ANALYZE` differs from `EXPLAIN` because it:

Question 2 of 8

Postgres uses MVCC, which means a row update:

Question 3 of 8

Which index type does Postgres use for a `@>` containment query on JSONB?

Question 4 of 8

A connection pooler in transaction mode is needed because:

Question 5 of 8

What does `SELECT ... FOR UPDATE` do?

Question 6 of 8

A sequential scan on a large table is chosen by the planner when:

Question 7 of 8

`VACUUM` exists mainly to:

Question 8 of 8

A partial index is:

0/8 answered

Part of