Együd Csaba (Freemail) <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
