Month: August 2011

Connection pooling, Why we go for connection pooling in PostgreSQL, When your application demands for very good number of concurrent connection hits then you need to approach it, because Connection pool sits between your application and the database. Idea behind connection pool is that you have enough connections to use of all the available resources…

In my recent post on pgmemcache, there were couple of questions asked which were really interesting and made me to work on it. I should thank for it 🙂 Questions:1. Is pgmemcache application transparent ?2. Is there any synchronization between memcached and PostgreSQL Shared buffers ? Answer: pgmemcache(memcached) is not application transparent, you need to…