Subject RE: [firebird-support] Newbie Question: Page_Size
Author Alan McDonald
> I apologize if this is a question asked often and well documented
> but I have
> searched the documentation and can't find a concise answer to
> this question.
> My question is, is there any significance to the PAGE_SIZE specified when
> the CREATE DATABASE command is issued? If so, does this limit the physical
> size of the database and therefore affect the amount of data able to be
> stored? Or does this have significance when record locks occur?
> Thanks in advance for your help!
> Regards,
> Chris - newbie Firebird User

It's significant to how much data is stored on a page (which is a chunk of
disk space reserved by the db server each time it expands the file).
It impacts performance by larger page size=fewer disk reads to access your
Most people will choose 4096 as the optimum size, it marries with Disk IO
behaviour. It's very rare that a different page size to this will lift
performance at all, but a page size of 1024 will reduce performance