"Jeff Frost" <[EMAIL PROTECTED]> writes:
> Before analyze it seems to choose Bitmap Heap Scan on episodes
> current_episode, but after it chooses Index Scan Backward using
> index_episodes_on_publish_on on episodes current_episode.
Have you tried raising the stats target for "episodes"? Seems like
the problem is a misestimate of the frequency of matches for
season_id = something.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
