Re: [GENERAL] Insufficient memory for this operation.

2004-12-14 Thread Együd Csaba (Freemail)
Sent: Tuesday, December 14, 2004 6:25 PM To: [EMAIL PROTECTED] Subject: Re: [GENERAL] Insufficient memory for this operation. Együd Csaba (Freemail) <[EMAIL PROTECTED]> writes: > shared_buffers = 2 # min 16, at least max_connections*2, 8KB each You can lower this to 10,000

Re: [GENERAL] Insufficient memory for this operation.

2004-12-14 Thread Greg Stark
Együd Csaba (Freemail) <[EMAIL PROTECTED]> writes: > shared_buffers = 2 # min 16, at least max_connections*2, 8KB each You can lower this to 10,000 or even lower. > max_connections = 100 > work_mem = 16384# min 64, size in KB That's 16M per connection with a maximu

Re: [GENERAL] Insufficient memory for this operation.

2004-12-13 Thread Együd Csaba (Freemail)
Hi, it wasn't that! :) That brrr.,*.:$;,^%^%roaaggh BDE :{ on the client side... that was the problem. There were stuck in connections in the BDE stack. After closing all BDE client, the problem went away. Sorry for disturbing ... I discover again and again that Postgres is really GOOD. If you