Re: Memcached for Database server - Mailing list pgsql-general

From Craig Ringer
Subject Re: Memcached for Database server
Date
Msg-id 4DD609A4.1000902@postnewspapers.com.au
Whole thread Raw
In response to Memcached for Database server  (Adarsh Sharma <adarsh.sharma@orkash.com>)
List 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

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Unique Session ID in PGSQL?
Next
From: Craig Ringer
Date:
Subject: Re: Memcached for Database server