Step 3 / Select topic Postgres Hard
What this bank covers
- Default isolation level
- REPEATABLE READ vs SERIALIZABLE
- MVCC
- CTE materialization fence
- Advisory locks
- EXCLUDE constraints
- Planner statistics
- Partial indexes
- TOAST (The Oversized-Attribute Storage Technique)
- SKIP LOCKED
- HOT updates
- Transaction ID wraparound
- Deadlock detection
- Advisory lock scope
- Streaming replication
- Write-ahead logging
- Synchronous replication
- Logical vs physical replication
- pg_dump snapshot consistency
- Parallel restore
- Autovacuum thresholds
- pgstattuple for bloat
- CLUSTER
- Extended statistics
- Custom operators
- Operator classes
- EXPLAIN BUFFERS
- EXPLAIN FORMAT JSON
- Process-per-connection model
- Pooling mode tradeoffs
- Serialization failure handling
- pg_stat_statements
- Extension mechanism
- Foreign data wrappers
- Inheritance constraint limits
- Partitioning vs inheritance
- Partition pruning timing
- LISTEN/NOTIFY limits
- Checkpoints
- Full page writes
- pg_stat_activity wait events
- CONCURRENTLY and lock strength
- Two-phase commit
- Snapshot too old
- Index-only scans
- BRIN indexes
- GIN internals
- Covering indexes (INCLUDE)
- n_dead_tup
- idle in transaction and vacuum
- Replication slots and WAL retention
- Row level security and ownership
- Sequences are non-transactional
- Identity columns
- Window frame modes
- WITH RECURSIVE cycles
- LATERAL joins
- Custom aggregates
- PL/pgSQL exception handling cost
- Event triggers
- Foreign key locking
- Deferrable constraints
- pg_upgrade link mode
- Logical decoding output plugins
- Replica identity
- Publication and subscription
- pg_repack
- Parallel query workers
- JIT compilation
- Join method selection
- work_mem and disk spills
- shared_buffers and OS cache
- effective_cache_size
- random_page_cost tuning
- autovacuum_max_workers
- Multixact IDs
- pg_stat_bgwriter
- Generated columns
- Domains
- GIN and array containment
- Full text search ranking
- pg_trgm trigram indexes
- ALTER EXTENSION UPDATE
- Cascade deletes without an index
- TABLESAMPLE
- Query normalization limits
- Hint bits
- Generic vs custom prepared plans
- Separate vacuum vs analyze thresholds
- Replication lag components
- wal_level and replication
- FILLFACTOR and HOT updates
- Expression (functional) indexes
- Constraint triggers and deferral
- Cancel vs terminate backend
- Composite types
- Range type canonicalization
- Cascade update cost
- Statement vs row trigger firing order
- unnest and array_agg
- Row-value comparisons for keyset pagination
- jsonb containment uses GIN indexes
- Partial indexes need a matching predicate
- CTE inlining and MATERIALIZED