Postgres Pro
Downloads
Home   >   mailing lists

Re: Bad performance of SELECT ... where id IN (...) - Mailing list pgsql-performance

From Robert Haas
Subject Re: Bad performance of SELECT ... where id IN (...)
Date
Msg-id 603c8f070910050501l784a3505nd62945405694b7d2@mail.gmail.com
Whole thread Raw
In response to Re: Bad performance of SELECT ... where id IN (...)  (Omar Kilani <omar.kilani@gmail.com>)
Responses Re: Bad performance of SELECT ... where id IN (...)
List pgsql-performance
Tree view 
On Sun, Oct 4, 2009 at 9:58 PM, Omar Kilani <omar.kilani@gmail.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

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: updating a row in a table with only one row
Next
From: Omar Kilani
Date:
Subject: Re: Bad performance of SELECT ... where id IN (...)