pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: markw@osdl.org
To: threshar@torgo.978.org
Cc: pgsql-performance@postgresql.org
Cc: linux-lvm@sistina.com
Subject: Re: backup/restore - another area.
Date: Tue, 14 Oct 2003 15:18:29 -0700 (PDT)
Message-ID: <200310142218.h9EMIWo27040@mail.osdl.org> (raw)
In-Reply-To: <878ynu9ed5.fsf@stark.dyndns.tv>

Jeff,

I'm curious to what kind of testing you've done with LVM.  I'm not
currently trying any backup/restore stuff, but I'm running our DBT-2
workload using LVM.  I've started collecting vmstat, iostat, and
readprofile data, initially running disktest to gauge the performance.

For anyone curious, I have some data on a 14-disk volume here:
	http://developer.osdl.org/markw/lvm/results.4/log/
	
and a 52-disk volume here:
	http://developer.osdl.org/markw/lvm/results.5/data/

Mark

>Jeff <threshar@torgo.978.org> writes:
>
> Idea #1:
> Use an LVM and take a snapshop - archive that.
> From the way I see it. the downside is the LVM will use a lot of space
> until the snapshot is removed.  Also PG may be in a slightly inconsistant
> state - but this should "appear" to PG the same as if the power went out.
> 
> For restore, simply unarchive this snapshot and point postgres at it. Let
> it recover and you are good to go.
> 
> Little overhead from what I see...
> I'm leaning towards this method the more I think of it.



view thread (14+ messages)  latest in thread

Message-ID: <200310142218.h9EMIWo27040@mail.osdl.org>
Permalink:  ../200310142218.h9EMIWo27040@mail.osdl.org/
Also on:    postgresql.org/message-id/200310142218.h9EMIWo27040@mail.osdl.org

 · 

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: markw@osdl.org, threshar@torgo.978.org, linux-lvm@sistina.com
  Subject: Re: backup/restore - another area.
  In-Reply-To: <200310142218.h9EMIWo27040@mail.osdl.org>

* 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