Does PG do an index recheck on every row that matches a BRiN index, even for ranges where it should know for certain that all rows match? It seems like it's only skipping the check for rows it's certain are filtered, not rows that match.https://gist.github.com/sgrif/374b53017c2698f35fd4db520f063bf3 …
See the link, this was a check where the data is laid out ideally for the index. Manually refreshing the index doesn't affect it
-
-
You're over thinking it. BRIN indexes aren't in sync with what's in the table. You can delete all matching rows and the BRIN index will still say "I once saw a min of X and a max of Y in this range of pages". https://gist.github.com/jamatthews/aee20e9184433228bc79e07d3204b271 …
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.