4. Managing Tables and Views : Table Management : Page Size Specification
 
Share this page                  
Page Size Specification
A page is a block of physical storage space.
The default page size is determined by the DBMS configuration parameter, default_ page_size. The corresponding buffer cache for the installation must also be configured with the page size you specify or you receive an error. For more information, see the chapter “Configuring Ingres” in the System Administrator Guide.
When you create a table using Director or VDBA, specify its page size by clicking Options in the New Table page or Create Table dialog, respectively. The Options dialog opens, which contains a Page Size drop-down list.
Note:  After creating a table, if you later need to add or drop a column, the page size of the table must be larger than 2 KB. If you anticipate that a particular table needs to be altered in either of these ways, create the table using a larger page size or modify its storage structure before attempting to alter the table. For more information, see the chapter “Maintaining Storage Structures.”