Re: Multi-Dimensional Histograms - Mailing list pgsql-hackers

From Nathan Boley
Subject Re: Multi-Dimensional Histograms
Date
Msg-id 6fa3b6e20906291649h5f78776dx77474ea615959982@mail.gmail.com
Whole thread Raw
In response to Re: Multi-Dimensional Histograms  (David Fetter <david@fetter.org>)
List pgsql-hackers
>> Finally, this creates the partition but ( AFAICT ) it doesn't describe
>> a method for locating the histogram estimate given a point ( although
>> that doesn't seem too difficult ).

> Is that "not difficult," in terms of the math that needs doing, or
> "not difficult," in terms of how well PostgreSQL is already set up to
> implement, or...?
>

I only meant that any implementation would need to address this, but I
can think of simple ways to do it ( for instance, use the fixed width
grid method, and then store a reference to all of the intersecting
boxes ). But I am sure that there are much better ways ( nested
containment lists perhaps? ).

-Nathan


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Query progress indication - an implementation
Next
From: Ron Mayer
Date:
Subject: Re: Query progress indication - an implementation