Re: [PERFORM] Slow queries on 9.3.1 despite use of index

2014-04-29 Thread Michael van Rooyen
On 2014/04/28 07:52 PM, Jeff Janes wrote: On Mon, Apr 28, 2014 at 10:12 AM, Michael van Rooyen mailto:mich...@loot.co.za>> wrote: It looks like something is causing your IO to seize up briefly. It is common for the sync phase of the checkpoint to do that, but that would only explain 3 of th

Re: [PERFORM] Revisiting disk layout on ZFS systems

2014-04-29 Thread Karl Denninger
On 4/29/2014 3:13 AM, Albe Laurenz wrote: Karl Denninger wrote: I've been doing a bit of benchmarking and real-world performance testing, and have found some curious results. [...] The odd thing is that I am getting better performance with a 128k record size on this application than I get wi

Re: [PERFORM] Revisiting disk layout on ZFS systems

2014-04-29 Thread Albe Laurenz
Karl Denninger wrote: > I've been doing a bit of benchmarking and real-world performance > testing, and have found some curious results. [...] > The odd thing is that I am getting better performance with a 128k record > size on this application than I get with an 8k one! [...] > What I am curio