File Format and Page Size

The default file format for Pervasive PSQL v10 is 9.5 (there is not a version 10.0 file format). Th 9.5 file format was available with Pervasive PSQL v9 SP2, but it is now the default.

The maximum size of a data file is 256 GB for a 9.5 format file.

The maximum page size has been increased to 16,384 bytes for a version 9.5 file. Only five page sizes are supported for a version 9.5 file:

1,024 bytes

2,048 bytes

4,096 bytes

8,192 bytes

16,384 bytes

For a version 9.5 file, if you specify a different page size (such as 512; 1,536; 2,560; 3,072; or 3,584), the database engine rounds up the size to the next supported size.

Note that files using file format 6.0 or higher are still fully accessible (read and write). Files with file format 5.x or older are read-only.