{"comment":{"created_at":"2011-10-11T08:14:23Z","body":"[springmeyer] after stopping postgres to drop all the idle in transaction connections, and re-running the benchmarkings I'm no longer seeing the \"Idle in transaction\" connections remaining - so perhaps this is now fixed.\r\n\r\nBut max_size is set to 20 on all layers and I'm not seeing the # of connections go over 13 as reported by `pg_stat_activity`.","updated_at":"2011-10-11T08:14:23Z","url":"https://api.github.com/repos/mapnik-org/mapnik/issues/comments/2358731","id":2358731,"user":{"avatar_url":"https://secure.gravatar.com/avatar/941f68386168a8a6b60f2529a7830af7?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","url":"https://api.github.com/users/artemp","id":59056,"login":"artemp"}},"action":"created","issue":{"number":853,"created_at":"2011-10-11T08:14:19Z","pull_request":{"diff_url":null,"patch_url":null,"html_url":null},"body":"We're seeing that we do not max out the CPU on the postgres machine for the foss4g benchmark. The machine stays 30% idle, which seems odd.\r\n\r\nPerhaps the connection pool is not working right?\r\n\r\nThe number of objects in a Postgres connection pool can go beyond `max_size`. https://github.com/mapnik/mapnik2/blob/master/include/mapnik/pool.hpp#L122 seems like a odd way of checking whether the desired amount of objects has already been created; when that code is run, `unusedPool_` should be 0, so when the pool is empty, mapnik creates new objects automatically.","comments":8,"title":"pool.hpp doesn't respect upper limit","updated_at":"2011-10-11T08:14:25Z","url":"https://api.github.com/repos/mapnik-org/mapnik/issues/853","id":1872558,"assignee":null,"milestone":null,"closed_at":null,"user":{"avatar_url":"https://secure.gravatar.com/avatar/941f68386168a8a6b60f2529a7830af7?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","url":"https://api.github.com/users/artemp","id":59056,"login":"artemp"},"html_url":"https://github.com/mapnik-org/mapnik/issues/853","labels":[{"name":"PostGIS_Input_Driver","url":"https://api.github.com/repos/mapnik-org/mapnik/labels/PostGIS_Input_Driver","color":"FFFFFF"}],"state":"open"},"legacy":{"issue_id":1872558,"comment_id":2358731}}