Re: Temporary tables and miscellaneous schemas

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: btober(at)seaworthysys(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Temporary tables and miscellaneous schemas
Date: 2003-10-12 17:27:39
Message-ID: 3892.1065979659@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<btober(at)seaworthysys(dot)com> writes:
> To follow-up then, if the temp schemas do not disappear, then over time
> what happens (as temp tables are instantiated during normal application
> usage), does the database end up with an ever-increasing number of these
> temp schemas?

No, you will never have more than max_connections of them.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message btober 2003-10-12 17:28:34 Re: Temporary tables and miscellaneous schemas
Previous Message Tom Lane 2003-10-12 16:51:05 Re: Temporary tables and miscellaneous schemas