"Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> writes: >> Fatal: 2149478 is outside the valid range for parameter >> "maintenance_work_mem" ............ > That is odd. I just testing on 8.1.3: > template1=# set maintenance_work_mem = 2149478; > SET I'm betting Joshua is testing on a 64-bit machine. Since 8.1, the max allowed value is dependent on sizeof(pointer) ... regards, tom lane