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] Insert vs Update

2015-07-15 Thread Michael Nolan
On Wed, Jul 15, 2015 at 3:16 PM, Robert DiFalco wrote: > > Thanks David, my example was a big simplification, but I appreciate your > guidance. The different event types have differing amounts of related data. > Query speed on this schema is not important, it's really the write speed > that matte

Re: [PERFORM] Insert vs Update

2015-07-15 Thread Michael Nolan
I On Wed, Jul 15, 2015 at 12:16 PM, Robert DiFalco wrote: > First off I apologize if this is question has been beaten to death. I've > looked around for a simple answer and could not find one. > > Given a database that will not have it's PKEY or indices modified, is it > generally faster to INSE

Re: [PERFORM] New server: SSD/RAID recommendations?

2015-07-07 Thread Michael Nolan
On Tue, Jul 7, 2015 at 10:59 AM, Heikki Linnakangas wrote: > On 07/07/2015 05:15 PM, Wes Vaske (wvaske) wrote: > >> The M500/M550/M600 are consumer class drives that don't have power >> protection for all inflight data.* (like the Samsung 8x0 series and >> the Intel 3x0 & 5x0 series). >> >> The M

Re: [PERFORM] Are there tuning parameters that don't take effect immediately?

2015-06-12 Thread Michael Nolan
On Fri, Jun 12, 2015 at 4:52 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, Jun 12, 2015 at 4:37 PM, Michael Nolan wrote: > >> The only thing I can come up that's happened since last night was that we >> ran the nightly vacuum analyze on that d

[PERFORM] Are there tuning parameters that don't take effect immediately?

2015-06-12 Thread Michael Nolan
Last night I was doing some tuning on a database The longest query I was running was taking around 160 seconds. I didn't see much change in the running time for that query, even after restarting PG. Today, with roughly the same system load (possibly even a bit heavier load), that query is runnin

Re: [PERFORM] Some performance testing?

2015-04-08 Thread Michael Nolan
On Wed, Apr 8, 2015 at 3:05 PM, Josh Berkus wrote: > On 04/07/2015 11:07 AM, Mel Llaguno wrote: > > Care to elaborate? We usually do not recommend specific kernel versions > > for our customers (who run on a variety of distributions). Thanks, M. > > You should. > > > http://www.databasesoup.com/2