Hacker News Reader

And make sure your `random_page_cost` is about 1.1 if running on an SSD or if >~98% of your hot pages fit in memory. Rather than 4 by default which makes the planner afraid of using indexes.

We added a weekly job to do that during low activity hours as a preventive measure. It's not often the planner incorrectly goes for a table scan due to bad statistics but when it does it's a big issue.

So we just so it proactively now.

there are ways to see out which indexes get used and which are not. It's surprising to find out table scans or incorrect indexes getting used.