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
