Search Postgresql Archives

Re: Why lots of temp schemas are being created

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Jun 8, 2009 at 6:57 AM, Anirban Pal<anirban.pal@xxxxxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux