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
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