Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)
Date: 1999-07-31 16:13:12
Message-ID: 13608.933437592@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

OK, I haven't heard any objections to my last proposal for improving
selectivity estimates for "=", so I'm going to bull ahead and implement it.

This will require adding columns to a system table, which I've never
done before. There are some attribute statistics in pg_attribute and
some in pg_statistic, but it looks like changing pg_attribute is a
pretty dangerous business, so I'm inclined to leave pg_attribute alone
and just add columns to pg_statistic.

Do I need to do anything beyond making the obvious additions to
catalog/pg_statistic.h, rebuild, and initdb? I see that pg_attribute.h
doesn't contain any handmade entries for pg_statistic, so that at least
is no problem...

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Roberth Andersson 1999-07-31 16:22:20 Re: [HACKERS] IPC Memory problem with Postmaster on BSDi 4.x
Previous Message Tom Lane 1999-07-31 15:55:45 Re: [HACKERS] IPC Memory problem with Postmaster on BSDi 4.x