Postgres Pro
Downloads
Home   >   mailing lists

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

From Amit Kapila
Subject Re: Very slow inner join query Unacceptable latency.
Date
Msg-id 003d01ce577c$af6535d0$0e2fa170$@kapila@huawei.com
Whole thread Raw
In response to Very slow inner join query Unacceptable latency.  (<fburgess@radiantblue.com>)
List pgsql-performance
Tree view 
On Wednesday, May 22, 2013 10:03 PM fburgess wrote:

> I did perform a explain analyze on the query.

Explain analyze doesn't help to collect statistics. You should use Analyze <table_name>.

Ideally optimizer should have slected the best plan, but just to check you can once try with

SET enable_hashjoin=off;

And see what is the plan it chooses and does it pick up index scan on larger table?

Could you please output of \d SARS_ACTS and \d SARS_ACTS_RUN?


With Regards,
Amit Kapila.

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Reliability with RAID 10 SSD and Streaming Replication
Next
From: Andrea Suisani
Date:
Subject: Re: Reliability with RAID 10 SSD and Streaming Replication