2010/3/7 zxo102 ouyang <zxo...@gmail.com> > 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 >
Do you have autovacuum running? And of course show the execution plans for the fast and the slow query (using explain analyze).
