Subject Re: [firebird-support] Re: One table become very slow
Author Vlad Khorsun
> Sorry, i was wrong. Gstat finished though. Isn`t taht too much pages
> for 9400 records?
>
> CLIENTS (132)
> Primary pointer page: 207, Index root page: 208
> Average record length: 288.79, total records: 9403
> Average version length: 9.00, total versions: 27565987, max
> versions: 6180
> Data pages: 209068, data page slots: 209849, average fill: 86%

You have A LOT of unused backversions. It seems you have bad
transaction control somewhere. The easiest you can do now to
improve things is to backup without garbage collection (gbak-g) and
restore.

Learn about transactions, versions and correct your application.

Regards,
Vlad