From: | "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_toast_temp_xx AND pg_temp_xx SCHEMAS |
Date: | 2009-03-10 19:06:28 |
Message-ID: | 3362F16682784477B31018D4DA6B223B@iptel.com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi guys,
In one of my databases (8.3.6) I have around 25 schemas with names like
these. There seem to appear a couple of new ones every now and then.
The only reference I found was this:
---
http://www.postgresql.org/docs/8.3/static/release-8-3.html
* 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.
---
Could anyone point me out some documentation about what these schemas mean?
Should I be worried? Anything I should do about it?
Thanks,
Fernando
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-03-10 19:29:09 | Re: pg_toast_temp_xx AND pg_temp_xx SCHEMAS |
Previous Message | Ivan Sergio Borgonovo | 2009-03-10 18:28:28 | Re: bug?: permission denied for schema on "on delete set null" |