> 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
data.
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
noticably.
Alan