| From: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> |
|---|---|
| To: | Anirban Pal <anirban(dot)pal(at)newgen(dot)co(dot)in> |
| Cc: | pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Why lots of temp schemas are being created |
| Date: | 2009-06-08 07:43:21 |
| Message-ID: | 2f4958ff0906080043hf82b4d8q236b4317308fd8af@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
On Mon, Jun 8, 2009 at 6:57 AM, Anirban Pal<anirban(dot)pal(at)newgen(dot)co(dot)in> wrote:
> Dear all,
>
> Our software use postgres as backend database. It works fine, strange thing
> is that, it creates so many temporary schemas under schema tab, names like
> pg_toast, pg_toast_temp_1 like this upto pg_toast_temp40. This schemas also
> reflected in "pg_namespace" table. Can anybody tell me, is there anything
> wrong in it? Should I get rid of these temporary schemas? Any suggestion
> on this, please.
you are a purist, bad habit.
Anything beginning with pg_* is an internal schema, don't touch it,
and no - you can't get rid of it.
--
GJ
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anirban Pal | 2009-06-08 08:28:47 | Re: Why lots of temp schemas are being created |
| Previous Message | Sebastien FLAESCH | 2009-06-08 07:20:29 | Re: INTERVAL SECOND limited to 59 seconds? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anirban Pal | 2009-06-08 08:28:47 | Re: Why lots of temp schemas are being created |
| Previous Message | Anirban Pal | 2009-06-08 05:57:51 | Why lots of temp schemas are being created |