Re: Unlogged vs. In-Memory

Bruce Momjian <bruce@momjian.us> wrote:

> I thought global temp tables were tables that existed as empty in
> every session and had per-session data.

Yeah -- they're not the *same* as unlogged tables.  What makes it
*similar* to me is that there is one definition visible to all
sessions, changes are not logged, and data is not necessarily
written to disk during normal operations, and on a crash all data is
lost.  The differences are that with unlogged tables all sessions
share the same data whereas with global temporary tables each
session has its own set of data, and on clean shutdown the unlogged
table will be saved for reload on startup.

-Kevin