Hi,
2011/05/17 14:31, Adarsh Sharma wrote:
Rick Genter wrote:
On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote:
Dear all,
I need to research on Memcache in the next few days.
What I want to know is it worth to have memcahed enable in our Mysql/ Postgres Production Servers.
We have databases from 20 to 230 GB and it's not the OLTP just a simple OLAP where data is fetched and stored in some meaningful format.
What are benefits& why we used memcahed?
What are the bottlenecks to meet?
You need to read about memcached. Memcached is not something you "enable". You have to program to it.
Thanks Rick, just one question..
At what stage we need memcached & what is the purpose of using it.
I just want to know whether it is worth to use memcahced or not as per our requirements.
I just built a software to enable query caching for PostgreSQL
with using memcached, which adds a proxy layer.
http://pgsnaga.blogspot.com/2011/03/postgresql-query-cache-pqc.html
Please take a look.
Thanks,
--
Rick Genter
rick.genter@xxxxxxxxx
--
NAGAYASU Satoshi <satoshi.nagayasu@xxxxxxxxx>
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general