I’m facing an issue with databases containing many… or few data.
My configuration is “wal-dir” = local hard drive, and “dir” = nfs share.
If i understand well, with “cache-snapshot-memory-size” = 25mo, when a database reaching 25mo on wal, flush is starting to write wal-dir data to dir data.
For my biggest database, i see theses flush ~every 5mn
But for small database… they are reaching 2mo after some days… so they are never flushed to nfs…
- If i modify “cache-snapshot-memory-size” to 2mo… my nfs server will hate me
- If i keep “cache-snapshot-memory-size” = 25mo and reboot a node… i loose data from small databases and metric readers will hate me
Is there any solution for this type of case ? For example a “cache-snapshot-max-time” is a dream for me
Thx in advance,