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 <[email protected]> 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
