should I reindex the table of more than 10 millions rows regularly when more data are inserted?

Поиск
Список
Период
Сортировка
От zxo102 ouyang
Тема should I reindex the table of more than 10 millions rows regularly when more data are inserted?
Дата
Msg-id 73ccced31003070739l3ef3db1av61c3a5c6efe44289@mail.gmail.com
обсуждение исходный текст
Ответы Re: should I reindex the table of more than 10 millions rows regularly when more data are inserted?  (Szymon Guz <mabewlun@gmail.com>)
Список pgsql-general
Hi everyone,
    I have a big table (more than 10 millions rows) and create an index (three columns) ( the index is not created with creating the table).  Within one day of the index created, the performance of query searching is ok.  But with more than several thousands rows of data  inserted into the table, query searching becomes slower and slower.  
   Should I recreate the index regularly when more data are inserted into the table? 

Thanks for your help in advance.


ouyang 

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: timestamp literal out of line
Следующее
От: Szymon Guz
Дата:
Сообщение: Re: should I reindex the table of more than 10 millions rows regularly when more data are inserted?