|Subject||Re: Performance when deleting a lot of records, again|
> You're not actually causing a sweep with the backup, just a garbageadding the "select count(*) from table" before a activate the indexes
> collect pass. Any non-indexed access to the tables has the same
didn't help. I still have an uncontrolled timeout in the backup
process when it's running on this table. The first 1'000'000 records
are backuped in reasonable time, then the backup task's seems to stop
for ever and something is going on (heavy disc access).
So it looks like the select statement is not enough.