Peter Eisentraut <[EMAIL PROTECTED]> writes: > Am Montag, 21. April 2008 schrieb Zdenek Kotala: >> set work_mem = 64; >> + ERROR: 64 is outside the valid range for parameter "work_mem" (256 .. >> 2097151) -- Test bitmap-and.
> This should probably be fixed by using a unit specification on work_mem. Do > you want to prepare a patch? The problem is that guc.c enforces a lower limit of 8*BLCKSZ on the work_mem setting. Unless we add an explicit unit specifier for "blocks" to GUC's vocabulary, there doesn't seem to be any way to name that value in the SET command. And it's not entirely clear that the SET would still have the desired effect for this test, anyway, if it were getting translated to 256K or more. Another possible answer is to change the minimum to be just 64K always. I'm not certain that it's really sensible to tie the minimum work_mem to BLCKSZ --- I don't think we do anything where work_mem is controlling a pool of page buffers, do we? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers