Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 21 May 2007 05:14:14 -0400
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
- Follow-Ups:
- Re: Rewriting DISTINCT and losing performance
- From: Chuck D.
- Re: Rewriting DISTINCT and losing performance
- References:
- Rewriting DISTINCT and losing performance
- From: Chuck D.
- Rewriting DISTINCT and losing performance
- Prev by Date: Re: Ever Increasing IOWAIT
- Next by Date: Re: Rewriting DISTINCT and losing performance
- Previous by thread: Rewriting DISTINCT and losing performance
- Next by thread: Re: Rewriting DISTINCT and losing performance
- Indexes: