Re: Query improvement

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: Mark <Marek(dot)Balgar(at)seznam(dot)cz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query improvement
Date: 2011-05-02 07:58:40
Message-ID: BANLkTinqa_YBD+qhuNqta=M8rqaZNFtE5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sun, May 1, 2011 at 12:23 PM, Mark <Marek(dot)Balgar(at)seznam(dot)cz> wrote:
> Now the problem.
> When I try ANALYZE it shows:

That's a regular explain... can you post an EXPLAIN ANALYZE?

Hash joins are very inefficient if they require big temporary files.
I usually work around that by disabling hash joins for the problematic queries:

set enable_hashjoin = false;
<query>
set enable_hashjoin = true;

But an explain analyze would confirm or deny that theory.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2011-05-02 09:06:28 Re: The right SHMMAX and FILE_MAX
Previous Message Adarsh Sharma 2011-05-02 04:53:15 Re: The right SHMMAX and FILE_MAX