Re: [PERFORM] Out of memory for Select query.

2008-06-29 Thread Rusty Conover
On Jun 29, 2008, at 10:20 PM, Nimesh Satam wrote: All, While running a Select query we get the below error: ERROR: out of memory DETAIL: Failed on request of size 192. Postgres Conf details: shared_buffers = 256000 work_mem =15 max_stack_depth = 16384 max_fsm_pages = 40 version: 8

[PERFORM] Out of memory for Select query.

2008-06-29 Thread Nimesh Satam
All, While running a Select query we get the below error: ERROR: out of memory DETAIL: Failed on request of size 192. Postgres Conf details: shared_buffers = 256000 work_mem =15 max_stack_depth = 16384 max_fsm_pages = 40 version: 8.1.3 We are using 8gb of Primary memory for the server