Re: Insufficient memory for this operation.

Együd Csaba (Freemail) <csegyud@freemail.hu> writes:

> shared_buffers  = 20000         # 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 maximum of 100 connections. So that's up to
1.6G that postgres has been told it can grab. It's unlikely it would grab it
all at once though unless lots of connections are running queries with big
sorts.

--
greg