Of course, no backup strategy is complete without testing a full restore onto bare hardware :-)
On Tue, Jun 22, 2010 at 9:29 AM, Karl Denninger <k...@denninger.net> wrote: > Justin Graf wrote: > > On 6/22/2010 4:31 AM, Grzegorz Jaśkiewicz wrote: > > > Would moving WAL dir to separate disk help potentially ? > > > > Yes it can have a big impact. > > WAL on a separate spindle will make a HUGE difference in performance. TPS > rates frequently double OR BETTER with WAL on a dedicated spindle. > > Strongly recommended. > > Be aware that you must pay CLOSE ATTENTION to your backup strategy if WAL > is on a different physical disk. Snapshotting the data disk where WAL is on > a separate spindle and backing it up **WILL NOT WORK** and **WILL** result > in an non-restoreable backup. > > The manual discusses this but it's easy to miss.... don't or you'll get a > NASTY surprise if something goes wrong..... > > -- Karl > > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > >
