Re: Infinite Cache

On 07/01/2011 06:37 PM, Jim Nasby wrote:
> BTW, thanks to the compression feature of IC I've heard it can
> actually be beneficial to run it on the same server.

Sure, its implementation works in a way that helps improve performance
on the database server. My point was that I'd be shocked if it were
even possible to double performance if you use it. Whereas putting a
pgmemcache server in front of the database can do much better than that,
on a system that reads the same things many times per update. "Infinite
Cache" is a useful technology and the fact that it work transparently
the application is a nice benefit of EDB's commercial product. But it's
usually the case that if you really want to do the best possible
implementation of an approach, optimizing very specifically for your
application is what's needed.

--
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
Comprehensive and Customized PostgreSQL Training Classes:
http://www.2ndquadrant.us/postgresql-training/