improve performance in a big table

Поиск
Список
Период
Сортировка
От A.Burbello
Тема improve performance in a big table
Дата
Msg-id 222808.5599.qm@web36215.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: improve performance in a big table  (olivier boissard <olivier.boissard@cerene.fr>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Dangerous hint in the PostgreSQL manual
Следующее
От: "kelvan"
Дата:
Сообщение: pgagent on a mac