Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)
Date
Msg-id 13608.933437592@sss.pgh.pa.us
Whole thread Raw
In response to Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] IPC Memory problem with Postmaster on BSDi 4.x
Next
From: Roberth Andersson
Date:
Subject: Re: [HACKERS] IPC Memory problem with Postmaster on BSDi 4.x