Обсуждение: Anyone use PG with kvm/virtio? Any gotchas or recommended settings?

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.

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.postgres@gmail.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@gmail.com
LlamaLand                       https://netllama.linux-sxs.org