Re: pg_temp_N temp schema buildup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jerry Sievers <jerry(at)jerrysievers(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_temp_N temp schema buildup
Date: 2004-05-21 06:11:37
Message-ID: 24356.1085119897@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jerry Sievers <jerry(at)jerrysievers(dot)com> writes:
> I'm running postgres 7.4.1 and notice an accumulation of temp schemas
> named pg_temp_1, pg_temp_2... etc.

That's intentional. Removing them just causes extra work to add them
again later (not to mention possibly crashing any backend that is
actively using one you remove).

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Nolan 2004-05-21 06:14:25 Re: Data change logs
Previous Message Tom Lane 2004-05-21 06:03:07 Re: Index not being used properly