32 MB. The page size is in bytes.
If you did not have enough memory, the server will refuse to open the
connection (needing the extra memory) if I remember well.
De : brucedickin...@wp.pl [mailto:brucedickin...@wp.pl]
Envoyé : 15 janvier 2014 14:53
À : firebird-support@yahoogroups.com
Objet :
rebuild the indices if I set them inactive/active but it is
impraticable in a 24/7 system because simultaneous queries raise exceptions.
Firebird 2.5.1 and 2.5.2 32 bits and 64 bits Superservers on Windows
Thank you for any advice !
Evelyne Girard
Thanks a lot for your answer Dimitry,
your problem is versions, because index keep all keys for all
versions. If you have active transactions, garbage collection
does not work, and obsolete keys and versions are not cleaned.
Check gstat -r to see how many versions tables have when you have
The triggers only modify current record on update. I’m not 100% sure it is the
dependant tables that the indexed reads do read … but it seemed a semi-logical
explanation since my update does a natural scan … if this weird behavior is
only happening in my databases I will try to find some time
