Josh Berkus wrote:
I was under the impression that work_mem would be used for the index if there
was an index for the RI lookup. Wrong?
Yes -- work_mem is not used for doing index scans, whether for RI
lookups or otherwise.
-Neil
---(end of
Josh Berkus wrote:
Michael,
Still, it seems like a convenient way to maintain cache coherency,
assuming that your application doesn't already have a clean way to do
that.
Precisely.The big problem with memory caching is the cache getting out of
sync with the database. Updating
Bruce,
The big concern I have about memcache is that because it controls
storage external to the database there is no way to guarantee the cache
is consistent with the database. This is similar to sending email in a
trigger or on commit where you can't be certain you send email always
and
The big concern I have about memcache is that because it controls
storage external to the database there is no way to guarantee the cache
is consistent with the database.
I've found that letting applications add data to memcache and then
letting the database replace or delete keys seems to be the