Re: [PERFORM] backup/restore - another area.

2003-10-16 Thread Jeff
On Tue, 14 Oct 2003, [EMAIL PROTECTED] wrote: 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

Re: [PERFORM] free space map usage

2003-10-16 Thread Robert Treat
On Tue, 2003-10-14 at 15:43, Jeremy M. Guthrie wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 14 October 2003 02:16 pm, Tom Lane wrote: Jeremy M. Guthrie [EMAIL PROTECTED] writes: Is there any way to determine how much of the free space map is currently i= n=20

Re: [PERFORM] backup/restore - another area.

2003-10-16 Thread Josh Berkus
Jeff, The downside is this method will only work on that specific version of PG and it isn't the cleanest thing in the world since you are essentially simulating a power failure to PG. Luckly the WAL works like a champ. Also, these backups can be much larger since it has to include the

Re: [PERFORM] backup/restore - another area.

2003-10-16 Thread Jeff
On Thu, 16 Oct 2003 09:49:59 -0700 Josh Berkus [EMAIL PROTECTED] wrote: Jeff, The downside is this method will only work on that specific version of PG and it isn't thecleanest thing in the world since you are essentially simulating a power failure to PG. Luckly the WAL works like a

Re: [PERFORM] backup/restore - another area.

2003-10-16 Thread Josh Berkus
Jeff, I left the DB up while doing this. Even had a program sitting around committing data to try and corrupt things. (Which is how I discovered I was doing the snapshot wrong) Really? I'm unclear on the method you're using to take the snapshot, then; I seem to have missed a couple posts

Re: [PERFORM] backup/restore - another area.

2003-10-16 Thread Jeff
On Thu, 16 Oct 2003 10:09:27 -0700 Josh Berkus [EMAIL PROTECTED] wrote: Jeff, I left the DB up while doing this. Even had a program sitting around committing data to try and corrupt things. (Which is how I discovered I was doing the snapshot wrong) Really? I'm unclear on the