Re: running in a virtual environment

From: Willy-Bas Loos <willybas(at)gmail(dot)com>
To: David Bear <David(dot)Bear(at)asu(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: running in a virtual environment
Date: 2010-08-27 16:07:16
Message-ID: AANLkTikgU+ELx91_XNQ7NHpGXpihPomwcHPVydOYRMMb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)Bear(at)asu(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message pavankumar reddy 2010-08-27 16:07:17 please help me
Previous Message Joshua D. Drake 2010-08-27 15:56:14 Re: running in a virtual environment