Re: Memcached for Database server

From: Satoshi Nagayasu <satoshi(dot)nagayasu(at)gmail(dot)com>
To: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Memcached for Database server
Date: 2011-05-17 05:38:13
Message-ID: 4DD209C5.2060900@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)genter(at)gmail(dot)com
>>
>>
>

--
NAGAYASU Satoshi <satoshi(dot)nagayasu(at)gmail(dot)com>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rick Genter 2011-05-17 05:52:41 Re: Memcached for Database server
Previous Message Adarsh Sharma 2011-05-17 05:31:24 Re: Memcached for Database server