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 > > >

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

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 pos

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 the"cleanest" thing in the world since you are essentially > > simulating a power failure to PG. Luckly the WAL wo

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 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 disktes