Page size and buffer cache size affect memory use and disk I/O throughput for the database.
The page size cannot be changed and determines the upper size limit on some database objects and whether LOB features can be used.
Sybase IQ swaps data in and out of memory in units of pages. When you create a database, you specify a separate page size for the catalog store and the IQ store. The temporary store has the same page size as the IQ store.
Page size for the catalog store has no real impact on performance. The default value of 4096 bytes should be adequate. The IQ page size determines two other performance factors, the default I/O transfer block size, and the maximum data compression for your database.
All I/O occurs in units of blocks. The size of these blocks is set when you create a Sybase IQ database; you cannot change it without recreating the database. By default, the IQ page size determines the I/O transfer block size. For example, the default IQ page size of 128KB results in a default block size of 8192 bytes. In general, Sybase IQ uses this ratio of default block size to page size, but it considers other factors also.
For a raw disk installation that uses a disk array, larger blocks may give better performance at the expense of disk space.
For a file system installation, to optimize performance over disk space, the IQ block size should be greater than or equal to the operating system's native block size, if there is one. You may get better I/O rates if your IQ block size matches your file system’s block size.