You can add location information to your Tweets, such as your city or precise location, from the web and via third-party applications. You always have the option to delete your Tweet location history. Learn more
BRIN indexes are lossy. The index just points to a page which contains at least one matching row, but there's no way the executor can know if all rows match and skip it.
My understanding is that it contains the max and min values for each range, allowing it to skip ranges which for sure don't match. Same logic should apply to ranges which for sure do match.
BRIN indexes are (mostly) maintained by auto vacuum in a lazy way so they need to recheck. They don't work anything like traditional indexing.
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
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.
