Re: [BUGS] query failed, not enough memory on 8.3.5

2008-11-30 Thread Grzegorz Jaskiewicz
On 2008-11-30, at 13:31, Greg Stark wrote: On Fri, Nov 28, 2008 at 8:08 PM, Grzegorz Jaskiewicz <[EMAIL PROTECTED]> wrote: work_mem = 128140 # min 64, size in KB maintenance_work_mem = 65535# min 1024, size in KB Incidentally it's very

[BUGS] query failed, not enough memory on 8.3.5

2008-11-28 Thread Grzegorz Jaskiewicz
hey folks (please CC, I'm not subscribed). I am trying to merge duplicates of two fields in a rather large table (139M rows, about 7GB of data). creating helper table, that would hold it. my feeling is, postgresql shouldn't go beyond memory bounds I am setting it in conf, never had any probl