Postgres Pro
Downloads
Home   >   mailing lists

Re: optimizing large query with IN (...) - Mailing list pgsql-performance

From Josh Berkus
Subject Re: optimizing large query with IN (...)
Date
Msg-id 200403120939.18797.josh@agliodbs.com
Whole thread Raw
In response to Re: optimizing large query with IN (...)  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-performance
Tree view 
Marcus,

> The problem, as I understand it, is that 7.4 introduced massive
> improvements in handling moderately large in() clauses, as long as they
> can fit in sort_mem, and are provided by a subselect.

Also, this problem may be fixed in 7.5, when it comes out.  It's a known
issue.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Sorting when LEFT JOINING to 2 same tables, even
Next
From: Greg Stark
Date:
Subject: Re: severe performance issue with planner