Christopher Kings-Lynne wrote:
Can you paste explain analyze and your effective_cache_size, etc. settings.
...
This seems like a case where PostgreSQL's current optimiser should
easily know what to do if your config settings are correct and you've
been running ANALYZE, so I'd like to see your settings and the explain
analyze plan...
I could, but it would divert us from the main topic of this discussion. It's not about that query, which was just an example. It's the larger issue.
Tom's earlier response tells the story better than I can:
This discussion has been had before (many times) ... see
the -hackers archives for detailed arguments.
If it's "been had before (many times)", and now I'm bringing it up again, then it's clearly an ongoing problem that hasn't been resolved.
Craig
