"Tom Lane" <[EMAIL PROTECTED]> writes:

> When complaining I hadn't read the pghackers thread in which you
> suggested this, and now that I'm caught up on email I remain
> unconvinced.  What do you need convert_to_scalar for in order to display
> the pg_statistic histogram?  You've already got the underlying data.

Then the charting tool would have to duplicate all the same code that
convert_to_scalar has to figure out what to do with the data.

What I can generate already is a bar chart for integer data types. But I think
it would be most useful for string data types. In one of the cases I've helped
someone with before they had comment spam constituting a sizable fraction of
their database throwing off statistics and forcing a sequential scan.

It might be simplest to expose an extern definition of the C function with a
comment saying it's internal and changes are planned.

Incidentally, I wonder if it makes more sense to make this an optional btree
operator class support procedure rather than a type function.

  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to