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@xxxxxxxxxxxxxxx Baltimore, MD Comprehensive and Customized PostgreSQL Training Classes: http://www.2ndquadrant.us/postgresql-training/ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
