Re: What is pg_toast_temp_* in my DB? - Mailing list pgsql-general

From André Fernandes
Subject Re: What is pg_toast_temp_* in my DB?
Date
Msg-id COL112-W59E70651093CAB5CE3BFC18A080@phx.gbl
Whole thread Raw
In response to What is pg_toast_temp_* in my DB?  (AI Rumman <rummandba@gmail.com>)
Responses Re: What is pg_toast_temp_* in my DB?  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general



Date: Tue, 4 Jan 2011 15:53:30 +0600
Subject: [GENERAL] What is pg_toast_temp_* in my DB?
From: rummandba@gmail.com
To: pgsql-general@postgresql.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.

pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: What is pg_toast_temp_* in my DB?
Next
From: Shoma S Achar
Date:
Subject: Updated Latch Patch