Subject Re: [firebird-support] Re: [Firebird-devel] Sweep process too many writes to disc
Author liviuslivius@poczta.onet.pl
> 2. DB Page Size is 16k and DefaultDBPageCache is 65536
>

>>Both good, I think. Very odd. I wonder if the size of the cache is
>>causing problems with the file system cache...

i disable system cache in fbconfig

> 3. database was backed up and restored
>
>>What did you use for gbak restore options?

normal option like in flamerobin all unchecked (garbage collector work, and disabled use all space if you think about this 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 index
>>entries. Could that be part of the problem?

l have ~4 indexes per table – but tables have not any constraints like pk, uk – if this is important info
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]