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