FreeBDS v10 ZFS config for PostgreSQL v9.3/4 DWH

zfsgetall.txt

# 16GB RAM / 6 x 10K RPM HDDs striped / 4 CPU
# DWH / OLAP workloads - 128K blocksize providing better querytimes
# Using old benchw datasets to compare platforms (http://benchw.sourceforge.net/)

# Started with these at OS install defaults, subsequently adjusting between 2 - 8 GB
kern.ipc.shmmax=8576069632
kern.ipc.shmall=2093767
kern.ipc.semmap=256

NAME           PROPERTY              VALUE                  SOURCE
ssdata/pgdata  aclinherit            restricted             default
ssdata/pgdata  aclmode               discard                default
ssdata/pgdata  atime                 off                    inherited from ssdata
ssdata/pgdata  available             969G                   -
ssdata/pgdata  canmount              on                     default
ssdata/pgdata  casesensitivity       sensitive              -
ssdata/pgdata  checksum              on                     default
ssdata/pgdata  compression           lz4                    local
ssdata/pgdata  compressratio         1.59x                  -
ssdata/pgdata  copies                1                      default
ssdata/pgdata  creation              Mon Jan 26 16:44 2015  -
ssdata/pgdata  dedup                 off                    default
ssdata/pgdata  devices               on                     default
ssdata/pgdata  exec                  on                     default
ssdata/pgdata  filesystem_count      none                   default
ssdata/pgdata  filesystem_limit      none                   default
ssdata/pgdata  jailed                off                    default
ssdata/pgdata  logbias               throughput             local
ssdata/pgdata  logicalreferenced     24.2G                  -
ssdata/pgdata  logicalused           24.2G                  -
ssdata/pgdata  mlslabel                                     -
ssdata/pgdata  mounted               yes                    -
ssdata/pgdata  mountpoint            /pgdata                local
ssdata/pgdata  nbmand                off                    default
ssdata/pgdata  normalization         none                   -
ssdata/pgdata  primarycache          all                    default
ssdata/pgdata  quota                 none                   default
ssdata/pgdata  readonly              off                    default
ssdata/pgdata  recordsize            128K                   default
ssdata/pgdata  redundant_metadata    all                    default
ssdata/pgdata  refcompressratio      1.59x                  -
ssdata/pgdata  referenced            15.2G                  -
ssdata/pgdata  refquota              none                   default
ssdata/pgdata  refreservation        none                   default
ssdata/pgdata  reservation           none                   default
ssdata/pgdata  secondarycache        all                    default
ssdata/pgdata  setuid                on                     default
ssdata/pgdata  sharenfs              off                    default
ssdata/pgdata  sharesmb              off                    default
ssdata/pgdata  snapdir               hidden                 default
ssdata/pgdata  snapshot_count        none                   default
ssdata/pgdata  snapshot_limit        none                   default
ssdata/pgdata  sync                  standard               default
ssdata/pgdata  type                  filesystem             -
ssdata/pgdata  used                  15.2G                  -
ssdata/pgdata  usedbychildren        0                      -
ssdata/pgdata  usedbydataset         15.2G                  -
ssdata/pgdata  usedbyrefreservation  0                      -
ssdata/pgdata  usedbysnapshots       0                      -
ssdata/pgdata  utf8only              off                    -
ssdata/pgdata  version               5                      -
ssdata/pgdata  volmode               default                default
ssdata/pgdata  vscan                 off                    default
ssdata/pgdata  written               15.2G                  -
ssdata/pgdata  xattr                 off                    temporary