Subject | Re: [firebird-support] Re: [Firebird-devel] Sweep process too many writes to disc |
---|---|
Author | liviuslivius@poczta.onet.pl |
Post date | 2013-01-05T22:25:57Z |
> 2. DB Page Size is 16k and DefaultDBPageCache is 65536i disable system cache in fbconfig
>
>>Both good, I think. Very odd. I wonder if the size of the cache is
>>causing problems with the file system cache...
> 3. database was backed up and restorednormal option like in flamerobin all unchecked (garbage collector work, and disabled use all space if you think about this options)
>
>>What did you use for gbak restore options?
also i see that db size not grow under sweep proces – then i suppose free space was enough for storing delete info – (but could be stored on the free unused pages also i do not know)
>> How about indexes? Sweep will be simultaneously removing indexl have ~4 indexes per table – but tables have not any constraints like pk, uk – if this is important info
>>entries. Could that be part of the problem?
and some indexes have depth 3, all others have depth 2 – if this is important info
I can prepare some db for exclusive fb-team test if wishes – this take some time but is possible
Karol Bieniaszewski
[Non-text portions of this message have been removed]