"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
