02.07.2015 13:45, [email protected] [firebird-support] wrote: > > here is the output from gstat. > > Database header page information: > Flags 0 > Checksum 12345 > Generation 500 > Page size 16384 > ODS version 11.2 > Oldest transaction 1 > Oldest active 2 > Oldest snapshot 2 > Next transaction 492 > Bumped transaction &nb sp; 1 > Sequence number 0 > Next attachment ID 2 > Implementation ID 16 > Shadow count 0 > Page buffers 0 > Next header page 0 > Database dialect 3 > Creation date Jul 1, 2015 10:50:27 > Attributes force write > > Variable header data: > Sweep interval: 20000 > *END* > > Gstat was started right after the restore. Is it normal to have so many > active transactions right after the database restore?
Yes. I suppose you used the -verbose switch, right? In this case each index is created in a separate transaction. Dmitry
