On Friday 27 August 2010 10:52:46 Adam PAPAI wrote: > > It seems postfix keeps-up 8-10-15 connections always, but i guess 2 or 3 > would be enough. The queries are very quick, so it's not necessary to > keep the SQL connection open. > > The documentation does not mention any part of this issue.
Read the documentation concerning proxymap, if all tables are proxied then the connections should be limited by the number of proxymap processes, and all will be efficient. Although Postgres shouldn't have a problem with many tens of simulateneous connections. Open connections from idle processes shouldn't be a big issue either. The problem I have seen is under dictionary attack a box hit a limit on database connections before the botnet drove it into the dust on some other parameter. Ensuring everything used proxymap meant that it took a much bigger botnet to stop our email working - che sera sera. So if the number of connections you are seeing is an issue already it might be worth considering how robust things might be when nasty things start happening (Postfix is amazingly good under such conditions I find, although sometimes it throws up the odd sub-optimal configuration choice - like my not using proxymap for all tables).
