improve performance in a big table - Mailing list pgsql-admin

From A.Burbello
Subject improve performance in a big table
Date
Msg-id 222808.5599.qm@web36215.mail.mud.yahoo.com
Whole thread Raw
Responses Re: improve performance in a big table  (olivier boissard <olivier.boissard@cerene.fr>)
List pgsql-admin
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/

pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Dangerous hint in the PostgreSQL manual
Next
From: "kelvan"
Date:
Subject: pgagent on a mac