Wednesday, July 20, 2016

Postgres on Btrfs

Postgres performs random writes on big database files, which can cause huge performance impact on files systems featured with COW(Copy On Write) like btrfs and zfs.

A good practice is add "nodatacow" option to database volume in /etc/fstab

Run
mount <mount-point> -o remount
to apply the edited mount options.

1 comment:

  1. Cool yesterday with a guy having fun. this is not what you thought we spent the whole night on this site nobbyall slots casino Cool slots and slot machines êàî rested neighing also earned money

    ReplyDelete