Sybase IQ needs more memory for buffer caches than for any other purpose. Sybase IQ has two buffer caches, one for the IQ Store and one for the Temporary Store. It uses these two buffer caches for all database I/O operations—for paging, for insertions into the database, and for backup and restore. Data is stored in one of the two caches whenever it is in memory. All user connections share these buffer caches. Sybase IQ keeps track of which data is associated with each connection.
Read the sections that follow for in-depth information on managing buffer caches:
For information on how to calculate your memory requirements, see “Determining the sizes of the buffer caches.”
For information on how to set buffer cache sizes once you know what they should be, see “Setting buffer cache sizes.”
For an example of how to determine appropriate buffer cache sizes, see Table 5-1.
