| 00:00.19 | *** join/#storm _mup_ (~mup@li37-90.members.linode.com) |
| 02:06.01 | *** join/#storm fcorrea (~fcorrea@bd21701f.virtua.com.br) |
| 03:09.02 | *** join/#storm fcorrea (~fcorrea@bd21701f.virtua.com.br) |
| 04:30.31 | *** join/#storm fcorrea (~fcorrea@bd21701f.virtua.com.br) |
| 04:31.24 | *** join/#storm fcorrea (~fcorrea@bd21701f.virtua.com.br) |
| 04:57.52 | *** join/#storm fcorrea (~fcorrea@bd21701f.virtua.com.br) |
| 04:59.59 | *** join/#storm jtravis (~jtravis@c-71-202-121-12.hsd1.ca.comcast.net) |
| 05:00.05 | *** part/#storm jtravis (~jtravis@c-71-202-121-12.hsd1.ca.comcast.net) |
| 06:23.21 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 08:09.12 | *** join/#storm esteve (~quassel@cli-5b7ee290.bcn.adamo.es) |
| 08:30.04 | *** join/#storm milosn (~milosn@5ac48559.bb.sky.com) |
| 09:09.33 | *** join/#storm bigjools (~quassel@82-71-93-254.dsl.in-addr.zen.co.uk) |
| 09:09.34 | *** join/#storm bigjools (~quassel@canonical/launchpad/bigjools) |
| 09:50.15 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 11:34.30 | *** join/#storm yosafbridge (~yosafbrid@li125-242.members.linode.com) |
| 11:46.01 | *** join/#storm niemeyer (~niemeyer@201-34-87-217.pltce701.dsl.brasiltelecom.net.br) |
| 11:46.01 | *** mode/#storm [+o niemeyer] by ChanServ |
| 12:34.16 | *** join/#storm milosn (~milosn@5ac48559.bb.sky.com) |
| 12:59.46 | *** join/#storm niemeyer (~niemeyer@201-34-87-217.pltce701.dsl.brasiltelecom.net.br) |
| 12:59.47 | *** mode/#storm [+o niemeyer] by ChanServ |
| 14:52.05 | *** join/#storm mgedmin (~mg@Maemo/community/contributor/mgedmin) |
| 14:52.16 | mgedmin | hi, folks! |
| 14:53.00 | mgedmin | our app is starting to hit postgresql connection limits |
| 14:53.35 | mgedmin | we have multiple sites served from one process; each has its own Store that connects to a different PG database |
| 14:53.48 | mgedmin | # of connections seems to be # of sites * # of threads |
| 14:54.01 | therve | correct |
| 14:54.15 | therve | because you need a different store every time |
| 14:54.20 | mgedmin | what's the best approach here? try to bump up the pg connection limit so it's more than 200? |
| 14:54.32 | mgedmin | or try to convince storm to be more aggressive about closing unused connections? |
| 14:54.40 | mgedmin | afaiu storm has no connection pooling? |
| 14:55.12 | therve | no it doesn't |
| 14:55.43 | therve | mgedmin, I guess your issue is that a good part of those connections is unused? |
| 14:56.13 | mgedmin | I'm not sure, actually... |
| 14:56.21 | mgedmin | it's a lottery which thread will process each request, I guess |
| 14:57.35 | therve | you can close the connection at every request I suppose |
| 14:57.50 | mgedmin | will Store re-open it automatically next time? |
| 14:57.52 | therve | otherwise, the "official" workaround is to use something like pgbouncer |
| 14:57.55 | therve | it will |
| 14:57.59 | mgedmin | ok |
| 14:58.04 | therve | there is a slight overhead though |
| 14:58.31 | mgedmin | for pgbouncer, or for opening connections? |
| 14:59.18 | therve | for opening connections |
| 14:59.26 | mgedmin | nods |
| 14:59.34 | mgedmin | reads about http://wiki.postgresql.org/wiki/PgBouncer |
| 14:59.50 | mgedmin | looks like it won't help if I use the default session pooling method |
| 14:59.56 | mgedmin | but might help if I use transaction pooling? |
| 15:00.56 | therve | right |
| 15:01.27 | mgedmin | so far upping the shmem limits and increasing the posgresql connection limit seems to be the simplest solution |
| 15:13.59 | *** join/#storm niemeyer (~niemeyer@201-34-87-217.pltce701.dsl.brasiltelecom.net.br) |
| 15:13.59 | *** mode/#storm [+o niemeyer] by ChanServ |
| 16:54.56 | *** join/#storm niemeyer_ (~niemeyer@201-34-87-217.pltce701.dsl.brasiltelecom.net.br) |
| 16:54.56 | *** mode/#storm [+o niemeyer_] by ChanServ |
| 17:01.43 | *** join/#storm niemeyer_ (~niemeyer@201-34-87-217.pltce701.dsl.brasiltelecom.net.br) |
| 17:01.44 | *** mode/#storm [+o niemeyer_] by ChanServ |
| 17:05.54 | *** join/#storm milosn (~milosn@5ac48559.bb.sky.com) |
| 17:10.55 | *** join/#storm milosn (~milosn@5ac48559.bb.sky.com) |
| 17:14.07 | *** join/#storm niemeyer (~niemeyer@201-34-87-217.pltce701.dsl.brasiltelecom.net.br) |
| 17:14.07 | *** mode/#storm [+o niemeyer] by ChanServ |
| 17:21.50 | *** join/#storm niemeyer_ (~niemeyer@201-34-87-217.pltce701.dsl.brasiltelecom.net.br) |
| 17:21.50 | *** mode/#storm [+o niemeyer_] by ChanServ |
| 17:27.05 | *** join/#storm lifeless (~robertc@122.58.129.196) |
| 22:23.36 | *** join/#storm m4v (~znc@unaffiliated/m4v) |
| 23:38.02 | *** join/#storm milosn (~milosn@5ac48559.bb.sky.com) |