Temp Space Page Size
Posted in 2013
Informix DBA — — source: IIUG Forums & Mailing Lists
Hi, We are running 11.70.FC7W2 on Solaris. I saw there was some discussion last year regarding temp space and using a page size larger than 2k. Is there a current recommendation for an OLTP system in terms of what page size to use for temp spaces ? Will the pages in 16k page size still really only be 2k for temp space? We currently use 2k (most data), 4k (indexes) and 8k (larger data). In this scenario, will there be a benefit from using a 16k page size and gain from the separate buffer pool for temp space? Any other suggestions? --Dave --089e013d1fdcfcf00104ed6ac9ae