Együd Csaba (Freemail) <csegyud(at)freemail(dot)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