Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Very slow inner join query Unacceptable latency. - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: [GENERAL] Very slow inner join query Unacceptable latency.
Date
Msg-id CAOR=d=1kwJn7rCWOH=XmvwGEWERCeYD3xnjbj4EGvTVWaoijSQ@mail.gmail.com
Whole thread Raw
In response to Re: Very slow inner join query Unacceptable latency.  (<fburgess@radiantblue.com>)
List pgsql-performance
Tree view 
Looking at the execution plan makes me wonder what your work_mem is
set to.  Try cranking it up to test and lowering random_page_cost:

set work_mem='500MB';
set random_page_cost=1.2;
explain analyze select ...

and see what you get.

pgsql-performance by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Very slow inner join query Unacceptable latency.
Next
From: Greg Smith
Date:
Subject: Re: Reliability with RAID 10 SSD and Streaming Replication