From: | Richard Sickler <richard(dot)sickler(at)avagotech(dot)com> |
---|---|
To: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
Cc: | David Bear <David(dot)Bear(at)asu(dot)edu>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: running in a virtual environment |
Date: | 2010-08-27 16:18:09 |
Message-ID: | AANLkTimwd2ykALGVz2Ho+7Gtake8bA82=mqjPr3zprV5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 <willybas(at)gmail(dot)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(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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2010-08-27 16:27:46 | Re: please help me |
Previous Message | pavankumar reddy | 2010-08-27 16:07:17 | please help me |