Score:0

Can WAL be turned of on CoW file systems?

cn flag

As far as I understand WAL in PostgreSQL designed for control of the integrity of Database. On File System same purpose is served by CoW (Copy-on-Write) mechanism.

So WAL look like some overhead. So can it be safely turned off? After all, the integrity of data can provide the file system itself.

djdomi avatar
za flag
myself would accept a little overwhelming overhead but nevertheless getting corrupted data whoxh f... your brain and nerves
Score:0
br flag

Copy on write does not give you integrity of the filesystem. Assuming that you meant filesystem journalling, which does give you filesystem integrity, then you should almost certainly still use Write Ahead Logging.

Write Ahead Logging in PostgreSQL gives you database integrity at the transaction level, typically increases performance, as well as giving point in time backup and allowing online backups.

The documentation is pretty good at explaining this.

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.