On Tuesday 04 January 2011 3:04:29 am André Fernandes wrote: > Date: Tue, 4 Jan 2011 15:53:30 +0600 > Subject: What is pg_toast_temp_* in my DB? > From: rummandba@xxxxxxxxx > To: pgsql-general@xxxxxxxxxxxxxx > > What is pg_toast_temp_* in my DB? > > Hello! > > pg_toast_temp_* are some special schemas where temporary tables are > created. Having > special schemas for temporary tables allows low-level code to recognize > such tables as temp ones, so we have many optimizations. > I believe that in the documentation there's more explanations about it. > > Regards, > Andre Fernandes. To get technical, temporary tables are put in pg_temp_* And per the release notes for 8.3: Place temporary tables' TOAST tables in special schemas named pg_toast_temp_nnn (Tom) This allows low-level code to recognize these tables as temporary, which enables various optimizations such as not WAL-logging changes and using local rather than shared buffers for access. This also fixes a bug wherein backends unexpectedly held open file references to temporary TOAST tables. -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
