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.
For Sybase IQ page size recommendations for the best performance, see “Choosing an IQ page size” in Chapter 5, “Working with Database Objects,” System Administration Guide: Volume 1.
Because the catalog store accounts for only a tiny fraction of I/O, the 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. These factors are discussed in the sections that follow.
