I have an 8.3.7 system running on a virtual machine hosted on Windows Server 2008 Hyper-V. I mapped virtual disks to real disks, (DAS), so that I have two physical spindles and two virtual spindles mapped to them, one each. Then followed normal good practices. WAL on one spindle, tables on the other. I have a script that runs every night and backs up the enter virtual machine.
On Fri, Aug 27, 2010 at 9:07 AM, Willy-Bas Loos <willy...@gmail.com> wrote: > Good question. I hear about putting WAL/indexes/tables on separate spindles > and all that, but what if all IO is virtualized? > I would guess that IO and OS page cache would be the main issues here. > i haven't dared to put my db on a virtual box though, because i don't know > what happens inside of it. > > > > On Fri, Aug 27, 2010 at 5:21 PM, David Bear <david.b...@asu.edu> wrote: > >> I'm wondering what experience people have had running pg 8.x in a >> virtualized environment. Are there any best practices to follow that >> differen when running on a real metal? Are there performance issue? What >> virtual environment seems most friendly to pg ? Xen, VMWare, other? What >> about storage; is it best to keep the cluster in a filesystem that is part >> of the vm-image or on a mounted file system that exists external to the >> image? (in other words, a /dev/sdxx that is really some NAS type of device, >> or NFS? CIFS?) >> >> -- >> David Bear >> College of Public Programs at ASU >> 602-494-0424 >> > > > > -- > "Patriotism is the conviction that your country is superior to all others > because you were born in it." -- George Bernard Shaw >