"John D. Burger" <john@xxxxxxxxx> writes:
> I'm now fiddling with some of the performance parameters, and I'm
> wondering about max_connections. The default appears to be 100 - this
> is at least an order of magnitude higher than I need. Would much be
> saved by dropping this down to 10 or less?
Nothing at all, really, AFAIK; just a little bit of shared memory.
On certain platforms (OS X at least) there is a penalty to oversized
max_connections because each per-backend-slot semaphore is an open file
that has to be passed down when a new backend process is forked. But
this is not true on Solaris. I doubt you'd see any difference.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
