Hi Helen,

Is term Cache and Page Buffers interchangeable?

I'm still learning Firebird, so if I understand you correctly, I can leave the page size set to 8192 and change the Page Buffer from 4096 to anywhere from 75 to 125?

Could you explain the benefit of using one page buffer setting over another?

Is there any formula to use when determining the best page size and page buffers to use?

What is the best way to handle fixing my issue with the broken pages? Is as one kind person (Vlad) suggested using ALTER INDEX <INDEX_NAME> ALTER followed by a COMMIT all that is needed, and then follow this with running gfix -v -f again after index rebuild?

Thanks so much for you help.

Mike

----- Original Message -----
From: Helen Borrie
To: firebird-support@yahoogroups.com
Sent: Thursday, April 02, 2009 4:53 AM
Subject: {Disarmed} Re: [firebird-support] Validation Issues - What do they mean, and how do I fix them? (More)


At 02:49 PM 2/04/2009, you wrote:
>Just in case it is needed here is the Database Statistics: Anyone see any issues with these settings under Firebird 1.5 Classic?
>
>Database header page information:
>
> Page size 8192
>
> Page buffers 4096

This will not do for Classic. I'm sure it's at least a part of the cause of your broken index pages: they are being left partly written when one or more Classic processes crash on out-of-memory.

For an 8KB page size, a default size around 75 to 125 pages should be ample.

./heLen




[Non-text portions of this message have been removed]