Re: [HACKERS] Index not used on simple select

From: Ole Gjerde <gjerde(at)icebox(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Index not used on simple select
Date: 1999-07-23 19:57:59
Message-ID: Pine.LNX.4.05.9907231445360.8120-100000@snowman.icebox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 23 Jul 1999, Tom Lane wrote:
> It looks like the highly skewed distribution of nsn values (what you
> sent me had 997 '' entries, only 3 non-empty strings) is confusing the

As a note, it doesn't seem to matter wether the field has '' or NULL.
Even after I do a update to set all all rows with '' to NULL, it still
does the same thing.

Also, my full set of data is not quite so skewed. The nsn field has about
450,000 non-empty rows in it.

Thanks,
Ole Gjerde

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Hollomon 1999-07-23 20:15:10 plperl intial pass
Previous Message Oleg Bartunov 1999-07-23 19:44:52 vacuum analyze problem