From: Chuck D. <pgsql-performance@nullmx.com>
To: pgsql-performance@postgresql.org
Subject: Re: Rewriting DISTINCT and losing performance
Date: Mon, 21 May 2007 11:13:23 -0600
Message-ID: <200705211113.24689.pgsql-performance@nullmx.com> (raw)
In-Reply-To: <46518525.9010407@archonet.com>
References: <200705202228.32129.pgsql-performance@nullmx.com>
<46518525.9010407@archonet.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pgsql-performance@nullmx.com
Subject: Re: Rewriting DISTINCT and losing performance
In-Reply-To: <200705211113.24689.pgsql-performance@nullmx.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox