In these days at work we’ve some trouble with a very slow PostgreSql Server… We need something like a Thread Pool.. but we couln’t modify the Server that call Postgres.
My Idea, that increase, in our case, more than 50% the response speed is to “limit” the postgres (postmaster for 7.4) instances.

This morning i’ve writed this PsLimit Source that do my “Scheduler” Job.

Usage:

pslimit <process name> <max number of instances>

Usage Example:

• Only 3 instances of postgres can run at the same time, the other will be queued
  • pslimit postgres 3 (Postgres 8.x)
  • pslimit postmaster 3  (Postgres 7.x)