I am using Postgres with Rails. Each rails application "thread" is actually a separate process (mongrel) with it's own connection. Normally, the db connection processes (?) look something like this in top: 15772 postgres 15 0 229m 13m 12m S 0 0.8 0:00.09 postgres: db db [local] idle These quickly grow as the application is used to 50+ Mb per instance. When I restart mongrel (the Rails application processes) these go back down to their normal small size. That makes me suspect this is not normal caching and there is some sort of unhealthy leak going on. Is there something Rails could be doing to cause these to grow? Maybe the connection is not being cleaned up properly? Is there some sort of connection cache going on? -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
