From: Greg Smith <greg@2ndQuadrant.com>
To: pgsql-performance@postgresql.org
Subject: Re: Infinite Cache
Date: Sun, 03 Jul 2011 14:18:16 -0400
Message-ID: <4E10B268.9090405@2ndQuadrant.com> (raw)
In-Reply-To: <6CEF0279-2FD6-4A55-B256-6DEDD124E799@nasby.net>
References: <BANLkTi=BWd5G_q2erCZK-Htd=CLU1n9R0Q@mail.gmail.com>
<6CEF0279-2FD6-4A55-B256-6DEDD124E799@nasby.net>
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@2ndQuadrant.com Baltimore, MD
Comprehensive and Customized PostgreSQL Training Classes:
http://www.2ndquadrant.us/postgresql-training/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: greg@2ndQuadrant.com
Subject: Re: Infinite Cache
In-Reply-To: <4E10B268.9090405@2ndQuadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox