Re: pg_toast_temp_xx AND pg_temp_xx SCHEMAS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_toast_temp_xx AND pg_temp_xx SCHEMAS
Date: 2009-03-10 19:29:09
Message-ID: 2297.1236713349@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar> writes:
> Could anyone point me out some documentation about what these schemas mean?

They're just there to hold temporary tables (so that the names of such
tables don't conflict with any non-temporary tables). The reason they
seem to accumulate is we only create one when needed, and there's one
for each concurrently executing backend if it creates any temp tables.

> Should I be worried? Anything I should do about it?

No, and no.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fernando Hevia 2009-03-10 19:34:23 Re: pg_toast_temp_xx AND pg_temp_xx SCHEMAS
Previous Message Fernando Hevia 2009-03-10 19:06:28 pg_toast_temp_xx AND pg_temp_xx SCHEMAS