On 8/12/2009 6:11 PM, Thom Brown wrote:
Your output shows that the xdf_admin_hierarchy tables between versions are drastically different. 8.3.8 only contains 1 row, whereas 8.4.1 contains 84211 rows.
That's just because one of them is doing a nested loop where it looks up a single row from xdf_admin_hierarchy via its primary key on each iteration. The other plan is doing a hash join on a sequential scan over xdf_admin_hierarchy so it reports all the rows at once.
-- Craig Ringer -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
