Daniele Varrazzo <daniele.varrazzo@gmail.com> writes:
> This suggests me that the PG histogram doesn't count the occurrence
> into bins of the same size over the domain, but instead records the
> boundaries on the domain of bins containing the same amount of data.
Right. I don't believe the PG planner has any issues with infinite
dates (and if you do find one, we'll do our best to fix it). But the
point that client-side code might not cope with infinite dates is
very valid, and that's not something that we can undertake to fix
if you run into it.
regards, tom lane