From: | markw(at)osdl(dot)org |
---|---|
To: | threshar(at)torgo(dot)978(dot)org |
Cc: | pgsql-performance(at)postgresql(dot)org, linux-lvm(at)sistina(dot)com |
Subject: | Re: backup/restore - another area. |
Date: | 2003-10-14 22:18:29 |
Message-ID: | 200310142218.h9EMIWo27040@mail.osdl.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-performance |
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(at)torgo(dot)978(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Carleton | 2003-10-15 00:51:33 | Error compiling 7.3.4 on Solaris 8 |
Previous Message | Christopher Browne | 2003-10-14 19:00:11 | Re: Lock! |
From | Date | Subject | |
---|---|---|---|
Next Message | Harry Broomhall | 2003-10-15 10:09:17 | Config error on emails? |
Previous Message | Peter Eisentraut | 2003-10-14 20:41:41 | Re: [PERFORM] Sun performance - Major discovery! |