In article <[EMAIL PROTECTED]>, ruben <[EMAIL PROTECTED]> writes:
> Today, one of the processes running daily took 4 hours when it takes > about 5 minutes. After a VACCUM ANALYZE of the affected tables it took > the same to finish, then I recreated (drop and create) the index of > the affected table and the process when again fast. My question is, > isn't enough to run a VACCUM to optimize a table and its indexes? Is > it advisable to recreate indexes from time to time? This was necessary in PostgreSQL up to 7.3.x, but 7.4.x is supposed to fix that. What version are you running? ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
