On Wed, 22 Sep 2004, Gaetano Mendola wrote:
> Limit (cost=10.21..10.21 rows=1 width=24) (actual time=0.885..0.885 rows=0 loops=1)
> Limit (cost=10.28..10.28 rows=1 width=24) (actual time=0.429..0.429 rows=0 loops=1)
These estimated costs are almost the same, but the runtime differs a bit.
This means that maybe you need to alter settings like random_page_cost,
effective_cache and maybe some others to make the cost reflect the runtime
better.
Since the costs are so close to each other very small changes can make it
choose the other plan. It's also very hard to make an estimate that is
correct in all situations. That's why it's called an estimate after all.
--
/Dennis Björklund