"Dan Langille" <dan(at)langille(dot)org> writes:
> I'm having fun with this one. It was nice and fast before the vacuum, but
> very
> slow afterwards. The idea is to get all the records for a given day.
[ scratches head... ] I tried to reproduce this, but for me it still
seems to prefer nestloop. Have you been playing any games with the
planner cost parameters? What does pg_stats show for these tables?
regards, tom lane