Joachim Worringen wrote:
> Potential issues that I see:
> - the ZFS ZIL will not benefit from a BBU (as it is connected to the
> backplane, driven by the onboard-RAID), and might be too small (32GB
> for ~2TB of data with lots of writes)?
This is a somewhat unpredictable setup. The conservative approach would
be to break two disks out of the larger array for the ZIL, running
through the battery-backed cache, rather than using the SSD drives for
that. The best way IMHO to use SSD for PostgreSQL is to put your large
indexes on it, so that even if the drive does the wrong thing when you
write and the index gets corrupted you can always rebuild them rather
than suffer data loss. Also, index writes really benefit from being on
something with low seek times, moreso than the ZIL or WAL.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us