Why lots of temp schemas are being created

From: "Anirban Pal" <anirban(dot)pal(at)newgen(dot)co(dot)in>
To: <pgsql-novice(at)postgresql(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Why lots of temp schemas are being created
Date: 2009-06-08 05:57:51
Message-ID: 056FD375A4E14EF592B0C4F2E2282AA5@central.newgen.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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 original 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 loss or damage arising from the use of the information transmitted by this email including damages from virus and further acknowledges that no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of NSTL.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gerhard Wiesinger 2009-06-08 06:35:20 Sum of multiplied deltas
Previous Message Gauthier, Dave 2009-06-08 02:19:43 Server admin for Clients ?

Browse pgsql-novice by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-06-08 07:43:21 Re: Why lots of temp schemas are being created
Previous Message Devrim GÜNDÜZ 2009-06-08 03:08:17 Re: Yum Update Errors