> FWIW, EnterpriseDB's "InfiniCache" provides the same caching benefit. The way > that works is when PG goes to evict a page from shared buffers that page gets > compressed and stuffed into a memcache cluster. When PG determines that a > given page isn't in shared buffers it will then check that memcache cluster > before reading the page from disk. This allows you to cache amounts of data > that far exceed the amount of memory you could put in a physical server.
So memcached basically replaces the filesystem? That sounds cool, but I'm wondering if it's actually a performance speedup. Seems like it would only be a benefit for single-row lookups; any large reads would be a mess. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance