On Fri, Aug 29, 2008 at 2:07 PM, Dave Page <[EMAIL PROTECTED]> wrote:
> On Fri, Aug 29, 2008 at 1:40 PM, Roberts, Jon <[EMAIL PROTECTED]> wrote:
>
> Oh, that's weird - that code is filtering out system objects client
> side for some reason. I'll look at that.
I've committed a change to filter out
"Roberts, Jon" <[EMAIL PROTECTED]> writes:
> This is what I'm trying to understand. At what point does PostgreSQL
> determine it needs to create a new temp schema versus reusing an
> existing one? Maybe we are doing something incorrectly in our code.
They're associated with backends' slot number
> On Fri, Aug 29, 2008 at 1:40 PM, Roberts, Jon
<[EMAIL PROTECTED]>
> wrote:
>
> >> Why have you got thousands of them? If you are running with
thousands
> >> of active backends, may I suggest a connection pooler?
> >>
> >
> > I don't know. It looks like a bug to me where a temp table is
created
On Fri, Aug 29, 2008 at 1:40 PM, Roberts, Jon <[EMAIL PROTECTED]> wrote:
>> Why have you got thousands of them? If you are running with thousands
>> of active backends, may I suggest a connection pooler?
>>
>
> I don't know. It looks like a bug to me where a temp table is created
> and dropped o
> -Original Message-
>
> "Roberts, Jon" <[EMAIL PROTECTED]> 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 i
On Thu, Aug 28, 2008 at 7:23 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> (It might be a good idea to fix pgAdmin so it ignores other sessions'
> temp schemas, though.)
It doesn't use them itself so normally you'll never see any. It will
show all of them if the Show System Objects option is turned o
"Roberts, Jon" <[EMAIL PROTECTED]> 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
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. This greatly slows down how long it takes pgAdmin to connect
because it retrieves thousands of pg_temp_% schemas.
We mainly use "drop on commit" and
