Why lots of temp schemas are being created - Mailing list pgsql-general

From Anirban Pal
Subject Why lots of temp schemas are being created
Date
Msg-id 056FD375A4E14EF592B0C4F2E2282AA5@central.newgen.local
Whole thread Raw
Responses Re: Why lots of temp schemas are being created
Re: Why lots of temp schemas are being created
List pgsql-general
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.
 
 
---  Thanks & Reagrds  ----
           Anirban Pal   


Disclaimer :- This e-mail and any attachment may contain confidential, proprietary or legally privileged information. If you are not the origin al intended recipient and have erroneously received this message, you are prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd (NSTL) accepts no responsibilities for los s or damage arising from the use of the information transmitted by this email including damages from virus and further acknowledges that no bin ding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of NSTL.

pgsql-general by date:

Previous
From: Gerhard Wiesinger
Date:
Subject: Sum of multiplied deltas
Next
From: Sebastien FLAESCH
Date:
Subject: Re: INTERVAL SECOND limited to 59 seconds?