Anyone use PG with kvm/virtio? Any gotchas or recommended settings? - Mailing list pgsql-general

From bubba postgres
Subject Anyone use PG with kvm/virtio? Any gotchas or recommended settings?
Date
Msg-id AANLkTimR+towxLqiadEtcc6g_j2jGPurm7QUo+svK+Xq@mail.gmail.com
Whole thread Raw
Responses Re: Anyone use PG with kvm/virtio? Any gotchas or recommended settings?
List pgsql-general

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.


pgsql-general by date:

Previous
From: Christian Ullrich
Date:
Subject: Using copy for WAL archiving on Windows
Next
From: Thomas Kellerer
Date:
Subject: Re: How can I find a schema that a table belong to?