Re: How to use brin_summarize_range

2019-08-23 Thread Michael Lewis
What is default_statistics_target set to? Or is there custom statistics value set for this table/column? Perhaps the planner is making sub-optimal choices because it only has a vague idea about the data and the histogram is not very informative. Planning time will increase when statistics target

Re: How to use brin_summarize_range

2019-08-23 Thread Jeremy Finzel
On Thu, Aug 22, 2019 at 1:46 PM Jeremy Finzel wrote: > Good afternoon! > > I am finding it difficult to understand how to maintain my BRIN index from > the docs. Specifically, this is the documentation on the > function brin_summarize_range which isn't clear to me: > >

How to use brin_summarize_range

2019-08-22 Thread Jeremy Finzel
Good afternoon! I am finding it difficult to understand how to maintain my BRIN index from the docs. Specifically, this is the documentation on the function brin_summarize_range which isn't clear to me: brin_summarize_range(index regclass, blockNumber bigint) integer - summarize the page