hello, all. I have a table about 2 million rows. when I run "select * from table1" in psql, it will take me about 10 minutes to get the result. I wonder if postgresql can immediately return result like db2.
After that I create a index on a column named id. The time executing "selct * from table1 where id=10" in psql is much faster than that of executing "select * from table1 where id <10" in psql. why? By the way I'm using postgresql 7.3. Who can tell me the reason. 3x. Jinqiang Han ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
