> > I did use that many values to actually force "compaction" and merging of > points into ranges. We only keep 32 values per page range, so with 2 > values we'll not build a range. You're right it may still trigger the > overflow (we probably still calculate distances, I didn't realize that), > but without the compaction we can't check the query plans. > > However, I agree 60 values may be a bit too much. And I realized we can > reduce the count quite a bit by using the values_per_range option. We > could set it to 8 (which is the minimum). >
I haven't read BRIN code, except the comments in the beginning of the file. From what you describe it seems we will store first 32 values as is, but later as the number of values grow create ranges from those? Please point me to the relevant source code/documentation. Anyway, if we can reduce the number of rows we insert, that will be good.
I don't think 60 values is excessive, but instead of listing them out by hand, perhaps use generate_series().
