Re: Unlogged vs. In-Memory
Kevin Grittner <kevin.grittner@wicourts.gov>
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Josh Berkus" <josh@agliodbs.com>, "Magnus Hagander" <magnus@hagander.net>
Cc: "PostgreSQL Advocacy" <pgsql-advocacy@postgresql.org>
Date: 2011-05-03T18:52:19Z
Lists: pgsql-hackers
Magnus Hagander <magnus@hagander.net> wrote: > They are *not* similar to in-memory table, in that they are > *always* written to disk. I thought we avoided flushing them to disk on checkpoint, or did that idea fall flat? Does the background writer flush them? If neither of these happens, then we can legitimately call them in-memory, as long as we point out that they are saved on a clean shutdown for reload on startup, and may be flushed from RAM at times when other objects need the memory. -Kevin