Question about DefaultDbCachePages

[Luciano Rodrigues Nunes Mendes]

Hi everyone,

I have a question regarding the behavior of the DefaultDbCachePages configuration parameter. According to the documentation, On SuperServer, the cache for each database will use (page count) * (page size).

My question is: If the database has fewer pages than the value set in DefaultDbCachePages, does Firebird still cache the number of pages specified in DefaultDbCachePages or does it cache the total number of pages in the database? In other words, if the database has 20K pages and DefaultDbCachePages is set to 30K pages, will the actual cache size be 20K or 30K pages?

Thanks in advance,

Luciano

[Dimitry Sibiryakov]

Luciano Rodrigues Nunes Mendes wrote 02.07.2026 17:24:
> My question is: If the database has fewer pages than the value set in
> DefaultDbCachePages, does Firebird still cache the number of pages specified in
> DefaultDbCachePages or does it cache the total number of pages in the database?

Cache pages are allocated on demand so not more than 20k pages will be
allocated for the database in your case.

--
WBR, SD.

[Luciano Rodrigues Nunes Mendes]

Thank you very much for the quick response and the clarifications, Dimitry!

Best Regards,

Luciano

--
Support the ongoing development of Firebird! Consider donating to the Firebird Foundation and help ensure its future. Every contribution makes a difference. Learn more and donate here:
https://www.firebirdsql.org/donate
---
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion, visit https://groups.google.com/d/msgid/firebird-support/eba325ae-1651-4d84-876c-b9d81d839511%40ibphoenix.com.