On Fri, 2003-02-14 at 04:59, Tomasz Myrta wrote:
> Brad Hilton wrote:
>
> > select * from articles where exists
> > (select 1 from article_categories, categories, category_map
> >where
> >article_categories.article_id = articles.id and
> >categories.restrict_views = FALSE and
> >
On Fri, 2003-02-14 at 14:08, Tom Lane wrote:
> Brad Hilton <[EMAIL PROTECTED]> writes:
> > ... If I modify the query slightly:
>
> >
> > select 1 from article_categories
> > -->
> > select 1 from articles, article_categories
> > -
>
> > the query takes 98 msec.
>
> Yeah, becau
On 14 Feb 2003, Brad Hilton wrote:
> I am hoping someone can help explain why modifying the following query
> can effect such a huge change in speed. The query is:
>
> select * from articles
> where exists
>( select 1 from article_categories
> where
> articl
