Re: Why would this slow the query down so much?

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Stuart Grimshaw <nospam(at)smgsystems(dot)co(dot)uk>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Why would this slow the query down so much?
Date: 2001-10-15 16:55:30
Message-ID: web-147949@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Stuart,

> ------------------------------------------
> SELECT a.category, b.headline, b.added, c.friendlyname
> FROM caturljoin as a
> INNER JOIN stories as b ON (a.url = b.source)
> INNER JOIN urllist as c ON (a.url = d.urn)
> WHERE a.category = 93 ORDER BY b.added DESC LIMIT 1;
> ------------------------------------------

Hmmm? Where did table "d" come from? If this is really your query,
that's your problem.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Szabo Zoltan 2001-10-15 19:41:10 index problem
Previous Message Aasmund Midttun Godal 2001-10-15 16:06:11 Re: problem w/plpgsql proc