"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
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
In response to
pgsql-general by date
|Next:||From: Pavel Stehule||Date: 2008-08-28 18:40:37|
|Subject: Re: SQL optimization - WHERE SomeField STARTING WITH ...|
|Previous:||From: Bill||Date: 2008-08-28 18:10:47|
|Subject: SQL optimization - WHERE SomeField STARTING WITH ...|