| From: | Mike G <mike(at)thegodshalls(dot)com> |
|---|---|
| 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-22 03:58:03 |
| Message-ID: | 20040522035803.GA3890@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I believe they are created when either a function / program creates a temporary table.
On Wed, May 19, 2004 at 08:32:06AM -0400, Jerry Sievers wrote:
> Hello.
>
> I'm running postgres 7.4.1 and notice an accumulation of temp schemas
> named pg_temp_1, pg_temp_2... etc.
>
> These schemas are empty and I have manually removed them from time to
> time.
>
> What procedure is leaving these behind and is there a way for me to
> have them cleaned up automatically after use?
>
> Thanks.
>
> --
> -------------------------------------------------------------------------------
> Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant
> 305 321-1144 (mobile http://www.JerrySievers.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Rylander | 2004-05-22 11:19:07 | Re: Am I locking more than I need to? |
| Previous Message | Octavio Alvarez Piza | 2004-05-22 00:55:21 | could not open relation "pg_trigger_tgrelid_tgname_index" |