Re: Rewriting DISTINCT and losing performance

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)nullmx(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Rewriting DISTINCT and losing performance
Date: 2007-05-21 09:14:14
Message-ID: 465162E6.4030205@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Chuck,

> explain analyze
> SELECT country_id, country_name
> FROM geo.country
> WHERE country_id IN
> (select country_id FROM geo.city)
> ;
>
> -- won't complete in a reasonable amount of time.

Can we see the plan?

--Josh

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2007-05-21 11:40:21 Re: Rewriting DISTINCT and losing performance
Previous Message Ralph Mason 2007-05-21 05:17:42 Re: Ever Increasing IOWAIT