Postgres Pro
Downloads
Home   >   mailing lists

Re: Rewriting DISTINCT and losing performance - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Rewriting DISTINCT and losing performance
Date
Msg-id 465162E6.4030205@agliodbs.com
Whole thread Raw
In response to Rewriting DISTINCT and losing performance  ("Chuck D." <pgsql-performance@nullmx.com>)
Responses Re: Rewriting DISTINCT and losing performance
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Ralph Mason"
Date:
Subject: Re: Ever Increasing IOWAIT
Next
From: Richard Huxton
Date:
Subject: Re: Rewriting DISTINCT and losing performance