Skip site navigation (1) Skip section navigation (2)

Re: Rewriting DISTINCT and losing performance

From: "Chuck D(dot)" <pgsql-performance(at)nullmx(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Rewriting DISTINCT and losing performance
Date: 2007-05-21 17:13:23
Message-ID: 200705211113.24689.pgsql-performance@nullmx.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Monday 21 May 2007 05:40, Richard Huxton wrote:
> Chuck D. wrote:
>
> Any good reason why country_id is NULLable?

It has been a while since I imported the data so it took some time to examine 
it but here is what I found.

In the original data, some cities do not have coutries.  Strange huh?  Most 
were in the Gaza Strip, No Man's Land or disputed territory where several 
countries claimed ownership.  This is according to USGS and the board of 
names.

Recognizing that this did me no good in my application I decided to repair 
that data so that country_id could have a NOT NULL modifier.



In response to

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2007-05-21 17:24:06
Subject: Re: pg_stats how-to?
Previous:From: Chuck D.Date: 2007-05-21 15:09:43
Subject: Re: Rewriting DISTINCT and losing performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group