Hacker News new | ask | show | jobs
by why-el 2169 days ago
You can also disable seq_scan and force pg to consider indexes, usually that's enough.
1 comments

Access method is just part of the story. Same index may be accessed in different ways, you might also want to combine them. Sometimes you may change table join order to see how it estimates (or executes). Usually there are two parts 1) cost and reasoning for some estimation 2) how it executes (timings, resource usage, locks/contention)