Re: [PERFORM] Performance problems with postgres and null Values?

2016-04-26 Thread Sven Kerkling
Thx. All queries are now running as usual. Thx for helping me. Best regards Sven -Ursprüngliche Nachricht- Von: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] Im Auftrag von Albe Laurenz Gesendet: Montag, 25. April 2016 10:08 An: 'Sven Kerkling

[PERFORM] Poor disk (virtio) Performance Inside KVM virt-machine vs host machine

2016-04-26 Thread Artem Tomyuk
Hi All. I've noticed that there is a huge (more than ~3x slower) performance difference between KVM guest and host machine. Host machine: dell r720xd RAID10 with 12 SAS 15 k drives and RAID0 with 2*128 GB INTEL SSD drives in Dell CacheCade mode. *On the KVM guest:* /usr/pgsql-9.4/bin/pg_test_f

Re: [PERFORM] Poor disk (virtio) Performance Inside KVM virt-machine vs host machine

2016-04-26 Thread Imre Samu
>I've noticed that there is a huge (more than ~3x slower) performance difference between KVM guest and host machine. I don't know that this is relevant or not , but there is an IBM research paper (Published in 2014) "IBM Research Report - An Updated Performance Comparison of Virtual Machines and L

Re: [PERFORM] Poor disk (virtio) Performance Inside KVM virt-machine vs host machine

2016-04-26 Thread Michael Nolan
On Tue, Apr 26, 2016 at 10:03 AM, Artem Tomyuk wrote: > Hi All. > > I've noticed that there is a huge (more than ~3x slower) performance > difference between KVM guest and host machine. > > Is this unique to KVM, or do similar things happen with other virtualizers? -- Mike Nolan

Re: [PERFORM] Poor disk (virtio) Performance Inside KVM virt-machine vs host machine

2016-04-26 Thread Artem Tomyuk
I didn't compare impact of virtualization on other hypervisors yet. 2016-04-26 18:21 GMT+03:00 Michael Nolan : > > > On Tue, Apr 26, 2016 at 10:03 AM, Artem Tomyuk > wrote: > >> Hi All. >> >> I've noticed that there is a huge (more than ~3x slower) performance >> difference between KVM guest and

Re: [PERFORM] Poor disk (virtio) Performance Inside KVM virt-machine vs host machine

2016-04-26 Thread Alan Hodgson
On Tuesday, April 26, 2016 11:21:15 AM Michael Nolan wrote: > On Tue, Apr 26, 2016 at 10:03 AM, Artem Tomyuk wrote: > > Hi All. > > > > I've noticed that there is a huge (more than ~3x slower) performance > > difference between KVM guest and host machine. > > Is this unique to KVM, or do similar

Re: [PERFORM] Poor disk (virtio) Performance Inside KVM virt-machine vs host machine

2016-04-26 Thread Merlin Moncure
On Tue, Apr 26, 2016 at 10:27 AM, Artem Tomyuk wrote: > I didn't compare impact of virtualization on other hypervisors yet. My rule of thumb is 50% hit for 1:1 host:guest. Virtualization is not free. If that's a pain try using 100% native solutions (docker, etc) merlin -- Sent via pgsql-pe