Re: Anyone use PG with kvm/virtio? Any gotchas or recommended settings?

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: bubba postgres <bubba(dot)postgres(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Anyone use PG with kvm/virtio? Any gotchas or recommended settings?
Date: 2011-01-19 19:05:29
Message-ID: AANLkTimVr0V==Z0f4by_+q8Vuj2CqXL3Vk9d3k01XOt3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm using it with Fedora14 inside the VM. No problems, although we've
only been using it for a few months. You sure that your host HW isn't
at fault?

On Wed, Jan 19, 2011 at 10:58 AM, bubba postgres
<bubba(dot)postgres(at)gmail(dot)com> wrote:
>
> Looks like the recommended settings are using the virtio interface,
> cache=none, and raw partitions (not qcow2).
> Anyone else run into any problems with kvm or virtio?
>
> We currently have a setup using qcow2, virtio, and the default cache
> settings, and experienced some data corruption (not preceded by crashes or
> restarts of postgres), and we are wondering if that might be the culprit.
>
>
>

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    netllama(at)gmail(dot)com
LlamaLand                       https://netllama.linux-sxs.org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-01-19 19:51:27 Re: Error during a dump (ts_selectivity, not found)
Previous Message Thomas Kellerer 2011-01-19 19:01:41 Re: How can I find a schema that a table belong to?