Subject Re: [firebird-support] GStat
Author Helen Borrie
At 11:41 AM 29/03/2005 +1200, you wrote:

>Hi Sandor
>
>Sorry about the delay in replying, we had a long weekend here in New
>Zealand. I have no idea why this is set or indeed where this is set.
>Where is this configured? Our DB is certainly has a number of edits
>taking place, we have plenty of RAM as well so this setting makes no sense.

RAM isn't in the picture. By default, page space is allocated on the basis
of leaving "headspace" for updates that might cause rows on the page to
increase slightly in size. It would make the difference between "updating
in place" and needing to allocate a new page.

Someone has run the gfix utility with the -use full switch. To return to
the condition where space is reserved, perform a database shutdown as
sysdba and run gfix -use reserve path/to/database

./hb