postgres

12345678910111213141516
Across
  1. 4. INSERT ... ON CONFLICT
  2. 5. Heap-Only Tuple; an optimization that allows row updates to skip index modifications if the indexed columns aren't changed.
  3. 7. Multi-Version Concurrency Control
  4. 9. Atomicity, Consistency, Isolation, Durability
  5. 10. Common Table Expression
  6. 13. Postgres’ elephant mascot
  7. 15. The efficient, binary format for storing semi-structured data; much faster than plain text JSON.
  8. 16. The Write-Ahead Log
Down
  1. 1. The Oversized-Attribute Storage Technique
  2. 2. A data structure (like a B-Tree) used to speed up the retrieval of rows from a table.
  3. 3. A secondary server that stays in sync with the primary, used for read scaling.
  4. 6. tool that allows developers to interact with a relational database using object-oriented code instead of writing raw SQL
  5. 8. index type for complex data types like geometric shapes or full-text search.
  6. 11. Show the execution plan of a query statement
  7. 12. index type designed for composite data where values that contain multiple elements inside them
  8. 14. The interactive, command-line terminal used to manage and query Postgres databases.