On Tue, Dec 8, 2009 at 7:12 AM, Craig Ringer <[email protected]> wrote: > 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.
I've been meaning to write a patch to show the places after the decimal point in that case. Rounding off to an integer is horribly misleading and obscures what is really going on. Although in this case maybe it would come out 1.000 anyway. ...Robert -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
