"Tomas Vondra" <tv@xxxxxxxx> writes: > Dne 5 Listopad 2014, 18:10, Tom Lane napsal(a): >> For some reason there's over 1000 times more rows in andalertsmatch in >> the 9.1.14 installation. I'm betting on a foulup somewhere in the data >> dump/restore process. > I'd bet that's mostly due to rescans in the merge join ... Doh, I should have thought of that :-(. But still, the difference in the number of final output rows is pretty compelling evidence that it's not really the same data. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general