Re: Very poor read performance, query independent

[Jeff Janes <jeff.janes@xxxxxxxxx>]

On Wed, Jul 12, 2017 at 3:04 AM, Charles Nadeau <charles.nadeau@xxxxxxxxx> wrote:

Jeff,

Here are the 2 EXPLAINs for one of my simplest query:

It looks like dstexterne and flowcompact are both views over flow.  Can you share the definition of those views?

I think the iowait > 12.5% is due to the parallel query execution.  But then the question is, why is it only 25% when you have 10 fold parallelism?

It certainly looks like you are doing more than 4MB/s there, so maybe something is wrong with the instrumentation, or how you are interpreting it.  

Although it is still less than perhaps it could do.  To put a baseline on what you can expect out of parallel seq scans, can you do something like:

explain (analyze, buffers) select avg(doctets) from flow;

Cheers,

Jeff