Filesystem

http://www.westnet.com/~gsmith/content/postgresql/TuningPGWAL.htm Notes about PostgreSQL WAL synchronizations methods

http://btrfs.wiki.kernel.org/index.php/Main_Page BTRFS is a new ZFS-like linux file system, it is present in the recent kernels with “experimental” status.

http://www.gluster.org/docs/index.php/GlusterFS fully-distributed network file system (fully = no separate meta-data servers ). Supports data redundancy (data can be stripped/mirrored across several nodes), supposed to be high performance. supports encryption and can be embedded in app server (i.e. apache won’t need to go through the kernel for FS access )

ftp://ftp.research.microsoft.com/pub/tr/TR-2006-45.pdf a paper from microsoft research comparing perfomance of 2 systems: metadata in db + files in fs vs. meatadata + files as blobs in db. Study uses MSSQL and NTFS. Datasets are in less than 1 GB size.