Re: Memcached for Database server

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>, pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Memcached for Database server
Date: 2011-05-20 06:26:44
Message-ID: 4DD609A4.1000902@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 20/05/11 13:00, Adarsh Sharma wrote:
> Thanks Craig,
>
> I spend some time on Memcahced and your explaination also helps.
> I think it is used only for applications where load is very high & users
> issue read only queries to the database.

Er, yes. You can't really cache queries that write to the database, and
it doesn't make sense to cache queries where the answers change for
every query. A cache is only useful where the same query returns the
same result (for a while, at least) and is executed very, very often.

> Can you give the Real Example where memcached is used heavily.

Google can. You'll need to build your independent research skills if
you're going to succeed at what you're doing; it will not work well for
you to rely on others making all the effort to explain everything to
you. You will usually get better results when you ask people for help if
you can show them that you have already made an effort to discover the
answer for yourself.

> fore.g How Facebook, You tube use it .

Five seconds on Google found:

http://www.facebook.com/note.php?note_id=39391378919

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-05-20 08:01:59 Re: Memcached for Database server
Previous Message Merlin Moncure 2011-05-20 00:07:39 Re: Unique Session ID in PGSQL?