[ADMIN] improve performance in a big table

Hi people,

I have a case and I got a doubt what should be the best ways.

One table has more than 150 million of rows, and I thought that could divided by state.
For each row has person ID, state and other informations, but the search would be done only by person ID (number column).

I can improve the query by putting index in that column, but is there any other ways?

Thank you.

      Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly