Ernie <[EMAIL PROTECTED]> writes:
> This query is very fast.
>
> cw=# SELECT distinct n.news_id, headline, link, to_char(created,
> 'mm-dd-hh24:mi'),
> cw-# created FROM news_article_summary n, news_cat nc WHERE n.news_id =
> nc.news_id AND
> cw-# created > CURRENT_TIMESTAMP-30 AND nc.code_i
Ernie <[EMAIL PROTECTED]> writes:
> Here's an explain on the above query:
Um, *which* query was that for? And what's the EXPLAIN output for
the other query?
regards, tom lane
Hello all,
In writing a perl/DBI based application for our customers, we noticed some very
intersting behavoir. Against 2 tables, running a select, when you we do a
WHERE clause with a lot of items in it ... the query is fast. When we do it
with just one or two items, its hugely slower! Enough
