On Tue, Jan 15, 2013 at 5:47 AM, Gurjeet Singh <singh.gurj...@gmail.com> wrote: > postgres=# select * from test_0_col_table ; > -- > (200000 rows)
Interestingly, PostgreSQL 9.2 has regressed here. Not sure if we care, but worth mentioning: psql (9.2.2) test=# select count(*) from foo1; count ---------- 10000000 (1 row) Time: 632.907 ms test=# select * from foo1; (No rows) Time: 1012.567 ms Regards, Marti -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers