Mario Splivalo <mario.splivalo@xxxxxxxxxx> writes: > I have 8.4.8 on producion and 8.4.9 on test, could that explain the > difference in plans chosen? I'd wonder first if you have the same statistics settings on both. The big problem here is that the estimation of the join size is bad (8588 versus 0). regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
