pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <greg@2ndquadrant.com>
To: Joachim Worringen <joachim.worringen@iathh.de>
Cc: postgresql performance <pgsql-performance@postgresql.org>
Subject: Re: optimal ZFS filesystem on JBOD layout
Date: Thu, 01 Jul 2010 15:15:16 +0100
Message-ID: <4C2CA2F4.8080501@2ndquadrant.com> (raw)
In-Reply-To: <4C2C94B8.6080606@iathh.de>
References: <4C2C94B8.6080606@iathh.de>

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




view thread (2+ messages)

Message-ID: <4C2CA2F4.8080501@2ndquadrant.com>
Permalink:  ../4C2CA2F4.8080501@2ndquadrant.com/
Also on:    postgresql.org/message-id/4C2CA2F4.8080501@2ndquadrant.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: greg@2ndquadrant.com, joachim.worringen@iathh.de
  Subject: Re: optimal ZFS filesystem on JBOD layout
  In-Reply-To: <4C2CA2F4.8080501@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox