← Graph

Unlogged table durability on connection reset

question 2 connections

Audience question: unlogged tables are wiped when the database is restarted — does the same happen on a connection reset? Answer: speaker doesn't think connection reset triggers it but confirms any database restart or crash (e.g. restarting the Docker container) will clear them. Ideal for CI (run migrations + all tests, then discard); awkward on local dev because automatic Docker/computer restarts leave the dev wondering whether they need to re-run migrations.

answer_summary
Connection reset likely doesn't wipe them, but any database restart or crash does. Fine for CI, confusing on local dev.
question Unlogged table durability on connection reset
about
Unlogged Tables concept
Asks whether a connection reset wipes unlogged tables.
question Unlogged table durability on connection reset
asked_at
Asked during the Q&A.

Provenance