Re: Slow queries salad ;)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: PFC <lists@xxxxxxxxxx>
Subject: Re: Slow queries salad ;)
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Tue, 25 Apr 2006 14:20:29 -0400
Cc: pgsql-performance@xxxxxxxxxxxxxx
Comments: In-reply-to PFC <lists@xxxxxxxxxx> message dated "Tue, 25 Apr 2006 19:53:15 +0200"
In-reply-to: <op.s8kry1nucigqcu@apollo13>
References: <op.s8kry1nucigqcu@apollo13>

PFC <lists@xxxxxxxxxx> 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

References:
- Slow queries salad ;)
  - From: PFC

Prev by Date: Large (8M) cache vs. dual-core CPUs
Next by Date: Re: planner not using index for like operator
Previous by thread: Slow queries salad ;)
Next by thread: Re: Slow queries salad ;)
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux