Re: [GENERAL] Slow after VACUUM, fast after DROP-CREATE INDEX

2004-08-06 Thread ruben
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

Re: [GENERAL] Slow after VACUUM, fast after DROP-CREATE INDEX

2004-08-06 Thread Harald Fuchs
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 tab