Home > mailing lists

Re: Slow queries salad ;) - Mailing list pgsql-performance

From	Tom Lane
Subject	Re: Slow queries salad ;)
Date	April 25, 2006 15:20:45
Msg-id	22918.1145989229@sss.pgh.pa.us Whole thread Raw
In response to	Slow queries salad ;) (PFC <lists@peufeu.com>)
List	pgsql-performance

Tree view

PFC <lists@peufeu.com> writes:
>     The IN() is quite small (150 values), but the two large tables are
> seq-scanned... is there a way to avoid this ?

Not in 8.1.  HEAD is a bit smarter about joins to Append relations.

            regards, tom lane

pgsql-performance by date:

From: Bill Moran
Date: 25 April 2006, 15:14:58
Subject: Large (8M) cache vs. dual-core CPUs

From: "Jim C. Nasby"
Date: 25 April 2006, 15:24:57
Subject: Re: planner not using index for like operator

Re: Slow queries salad ;) - Mailing list pgsql-performance

Previous

Next