Re: any hope for my big query?

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

To: Ben <bench@xxxxxxxxxxxxxxx>
Subject: Re: any hope for my big query?
From: "Jim C. Nasby" <jim@xxxxxxxxx>
Date: Thu, 28 Sep 2006 19:09:15 -0500
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <Pine.LNX.4.64.0609281505360.21293@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
References: <Pine.LNX.4.64.0609281505360.21293@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
User-agent: Mutt/1.5.11

Instead of the IN, see if this is better:

AND (SELECT count(*) FROM albumjoin aj WHERE aj.album = album.id)
BETWEEN 15 AND 25.

References:
- any hope for my big query?
  - From: Ben

Prev by Date: Re: Performace Optimization for Dummies
Next by Date: Re: Performace Optimization for Dummies
Previous by thread: any hope for my big query?
Next by thread: Re: any hope for my big query?
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