Re: What is pg_toast_temp_* in my DB?

From: André Fernandes <andre(dot)de(dot)camargo(dot)fernandes(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: What is pg_toast_temp_* in my DB?
Date: 2011-01-04 11:04:29
Message-ID: COL112-W59E70651093CAB5CE3BFC18A080@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Date: Tue, 4 Jan 2011 15:53:30 +0600
Subject: [GENERAL] What is pg_toast_temp_* in my DB?
From: rummandba(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message asti1987 2011-01-04 12:06:48 Warning: database postgres must be vacuumed within 1000000 transactions
Previous Message AI Rumman 2011-01-04 09:53:30 What is pg_toast_temp_* in my DB?