PostgreSQL Strange Timings

A very simple query. PostgreSQL 8.4. I have no idea why the simple query is 7 times faster than the EXPLAIN ANALYZE version. Any ideas? Anyone? test_counters=# SELECT COUNT(*), xtype FROM test GROUP BY xtype ORDER BY xtype; count | xtype ———+——- 669000 | A 84000 | B 63000 | D 15000 | E 159000 […]

Continue reading →