Re: [PERFORM] Very poor read performance, query independent

Scott, The temp tablespace is on a disk of his own. Thanks! Charles On Sat, Jul 15, 2017 at 7:58 PM, Scott Marlowe wrote: > On Sat, Jul 15, 2017 at 11:53 AM, Charles Nadeau > wrote: > > Mark, > > > > I increased the read ahead to 16384 and

Re: [PERFORM] Very poor read performance, query independent

Igor, I set the work_mem to 12GB, restarted postrgresql, repeat the same "explain (analyze, buffers)..." as above and the read throughput was very low, at most 10MB/s. All the sorting operation are now done in memory. I lowered the work_mem back to 6GB, restarted postrgresql, repeat the same