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

Started by bubba postgresabout 15 years ago2 messagesgeneral
Jump to latest
#1bubba postgres
bubba.postgres@gmail.com

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.

#2Lonni J Friedman
netllama@gmail.com
In reply to: bubba postgres (#1)
Re: Anyone use PG with kvm/virtio? Any gotchas or recommended settings?

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