Page size - changing after database creation

Hi,

I was wondering, is it safe to change page size after database is created and filled with data? Should I set page size to the same value as block size on my filesystem?

The page size configuration setting should only affect new created databases, so it should be fine to change it (after a backup, to be on the safe side), but you will have to create a new database file, e.g. by running the Doctor in fix mode, for this setting change to take effect.

The optimal page size is affected by many factors. The system block size is only one of them. Therefore, the only way to optimize this for a specific system is to benchmark different settings. The default (2KB) works well in the general case.