"Sam Liddicott" <sam.liddicott@ananova.com> writes:
> O notice missing in the 7.2.1 (slow) explain analyse this part:
> "Index Scan using idx_broadcast_channelregionid on broadcast"
Indeed. What do 7.2 and 7.2.1 have in the pg_stats row for
broadcast.channelregionid? What is the real distribution of that
column?
regards, tom lane