On Sat, Apr 16, 2011 at 2:33 PM, Joshua Berkus <j...@agliodbs.com> wrote: > Well, given the risks to durability and stability associated with using MMAP, > I doubt anyone would even consider it for a 10% throughput improvement. > However, I don't think the test you used demonstrates the best case for MMAP > as a performance improvement.
Actually, I'd walk through fire for a 10% performance improvement if it meant only a *risk* to stability. The problem is that this is likely unfixably broken. In particular, I think the first sentence of Tom's response hit it right on the nose, and mirrors my own thoughts on the subject. To have any chance of working, you'd need to track buffer pins and shared/exclusive content locks for the pages that were being accessed outside of shared buffers; otherwise someone might be looking at a stale copy of the page. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
