Re: Bad performance of SELECT ... where id IN (...)

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Omar Kilani <omar(dot)kilani(at)gmail(dot)com>
Cc: Xia Qingran <qingran(dot)xia(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Bad performance of SELECT ... where id IN (...)
Date: 2009-10-05 12:01:13
Message-ID: 603c8f070910050501l784a3505nd62945405694b7d2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sun, Oct 4, 2009 at 9:58 PM, Omar Kilani <omar(dot)kilani(at)gmail(dot)com> wrote:
> Hi Xia,
>
> Try this patch:
>
> http://treehou.se/~omar/postgresql-8.4.1-array_sel_hack.patch
>
> It's a hack, but it works for us. I think you're probably spending
> most of your query time planning, and this patch helps speed things up
> 10x over here.

Woof. I can see that helping in some situations, but what a foot-gun!

...Robert

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Omar Kilani 2009-10-05 12:24:35 Re: Bad performance of SELECT ... where id IN (...)
Previous Message Merlin Moncure 2009-10-05 11:50:40 Re: updating a row in a table with only one row