On Mon, Mar 25, 2013 at 4:49 PM, Michael Paquier <michael.paquier@xxxxxxxxx> wrote: > > > On Tue, Mar 26, 2013 at 8:26 AM, Lonni J Friedman <netllama@xxxxxxxxx> > wrote: >> >> I'm pretty sure that unlogged tables and temp tables are two separate >> & distinct features, with no overlap in functionality. It would be >> nice if it was possible to create an unlogged temp table. > > Temporary tables are a subtype of unlogged tables, as temporary tables are > not WAL-logged. > This article from Robert Haas will give a good summary of such differences: > http://rhaas.blogspot.jp/2010/05/global-temporary-and-unlogged-tables.html Thanks, that's good to know. the official dox don't really make it clear that temp tables are unlogged. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general