Thanks Harald, i'm running PostgreSQL 7.1.3.
Harald Fuchs wrote:
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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
