Re: Very slow inner join query Unacceptable latency.

From: Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
To: <fburgess(at)radiantblue(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Very slow inner join query Unacceptable latency.
Date: 2013-05-23 06:13:44
Message-ID: 003d01ce577c$af6535d0$0e2fa170$@kapila@huawei.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Browse pgsql-performance by date

  From Date Subject
Next Message Andrea Suisani 2013-05-23 06:56:50 Re: Reliability with RAID 10 SSD and Streaming Replication
Previous Message Joshua D. Drake 2013-05-23 02:51:45 Re: Reliability with RAID 10 SSD and Streaming Replication