The difference is - you're fetching\grouping 8 times less rows than I:Huh? The explain output certainly doesn't show that.
Why not? My output: Buffers: shared hit=1486949 Torsten's output: Buffers: shared hit=155711This is amount of rows fetched for further processing (when all data is in memory), isn't it?
-- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance