From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Dave Page <dpage(at)pgadmin(dot)org> |
Cc: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: [Fwd: Re: [GENERAL] temp schemas] |
Date: | 2008-08-28 21:05:41 |
Message-ID: | 48B71325.4000406@hagander.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Actually, might it be an idea to stick the temp tables in their own
"subnode", that won't be loaded unless someone actually intentionally
looks at it?
//mha
Dave Page wrote:
> No, user error.
>
> On Thu, Aug 28, 2008 at 7:53 PM, Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> wrote:
>> May be a TODO item here.
>>
>> -------- Forwarded Message --------
>>> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>>> To: Roberts, Jon <Jon(dot)Roberts(at)asurion(dot)com>
>>> Cc: pgsql-general(at)postgresql(dot)org
>>> Subject: Re: [GENERAL] temp schemas
>>> Date: Thu, 28 Aug 2008 14:23:10 -0400
>>>
>>> "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com> writes:
>>>> I am noticing a large number of temp schemas in my database. We use
>>>> temp tables but it doesn't appear that the schemas get dropped for some
>>>> reason.
>>> That's intentional. There doesn't seem a lot of value in dropping a
>>> catalog entry that'll just have to be created again later.
>>>
>>>> This greatly slows down how long it takes pgAdmin to connect
>>>> because it retrieves thousands of pg_temp_% schemas.
>>> Why have you got thousands of them? If you are running with thousands
>>> of active backends, may I suggest a connection pooler?
>>>
>>> (It might be a good idea to fix pgAdmin so it ignores other sessions'
>>> temp schemas, though.)
>>>
>>> regards, tom lane
>>>
>> --
>> Devrim GÜNDÜZ, RHCE
>> devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
>> http://www.gunduz.org
>>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | svn | 2008-08-28 22:08:52 | SVN Commit by guillaume: r7433 - in trunk/pgadmin3/pgadmin: dlg include/dlg ui |
Previous Message | Dave Page | 2008-08-28 19:12:36 | Re: [Fwd: Re: [GENERAL] temp schemas] |