i(dot)frolkov(at)postgrespro(dot)ru writes:
> See two explain analyze below:
I see no particular bug here. Given the speeds you're getting out of that
inner indexscan, you need to increase effective_cache_size and/or reduce
random_page_cost to reflect actual execution costs on your hardware.
regards, tom lane