Temporary Storage Page Size
Specifies the standard memory allocation granule for Relay Services Gateway (RSG) temporary storage.
1 through 1024 KB
Changes Take Effect
After the next Teradata Database restart.
If a transaction contains any record that exceeds the standard page size, the RSG allocates memory from the large page size defined by the TempLargePageSize field. If the large page size is not sufficient to hold the record, the entire transaction is spilled to disk.
Note: Pages are not shared between transactions, so an increase in the page size may cause a decrease in storage utilization efficiency.