Peter Eisentraut wrote:
Am Donnerstag, 31. August 2006 15:43 schrieb stark:
This doesn't look right to me:
It's the whole metric system thing.... ;)
postgres=# set work_mem='1GB';
SET
postgres=# show work_mem;
work_mem
----------
1MB
(1 row)
Fixed.
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings