Re: [PATCHES] Export user visible function to make use of convert_to_scalar

2007-08-01 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: I was planning to use the first and last histogram values for the frame of reference. It could still produce some weird graphs but those cases are precisely the cases where users

Re: [PATCHES] Export user visible function to make use of convert_to_scalar

2007-07-31 Thread Tom Lane
Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Attached is a patch which implements, as discussed briefly on -hackers, a . user-visible function to get at the information that convert_to_scalar uses to generate selectivity

Re: [PATCHES] Export user visible function to make use of convert_to_scalar

2007-07-31 Thread Gregory Stark
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

Re: [PATCHES] Export user visible function to make use of convert_to_scalar

2007-07-31 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: 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

Re: [PATCHES] Export user visible function to make use of convert_to_scalar

2007-07-31 Thread Tom Lane
Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: How so? The entries in the histogram are equidistant by definition. Huh? They have equal number of values between them, they're not equidistant in the scalar space. So the area of each bar should be the same but the

Re: [PATCHES] Export user visible function to make use of convert_to_scalar

2007-07-31 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: How so? The entries in the histogram are equidistant by definition. Huh? They have equal number of values between them, they're not equidistant in the scalar space. So the area

Re: [PATCHES] Export user visible function to make use of convert_to_scalar

2007-07-31 Thread Tom Lane
Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: You're presuming there exists a linear scalar space to reference the results to. I was planning to use the first and last histogram values for the frame of reference. It could still produce some weird graphs but those

[PATCHES] Export user visible function to make use of convert_to_scalar

2007-07-30 Thread Gregory Stark
Attached is a patch which implements, as discussed briefly on -hackers, a user-visible function to get at the information that convert_to_scalar uses to generate selectivity estimates. The main use case for this is for tools such as pgadmin which want to make sense of the histograms, they need

Re: [PATCHES] Export user visible function to make use of convert_to_scalar

2007-07-30 Thread Tom Lane
Gregory Stark [EMAIL PROTECTED] writes: Attached is a patch which implements, as discussed briefly on -hackers, a user-visible function to get at the information that convert_to_scalar uses to generate selectivity estimates. This is an astonishingly bad idea, as it exposes and thereby sets in

Re: [PATCHES] Export user visible function to make use of convert_to_scalar

2007-07-30 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Attached is a patch which implements, as discussed briefly on -hackers, a user-visible function to get at the information that convert_to_scalar uses to generate selectivity estimates. This is an astonishingly bad