Re: 5 pg_toast_temp and pg_temp schemas ? - Mailing list pgsql-admin

From Josh Kupershmidt
Subject Re: 5 pg_toast_temp and pg_temp schemas ?
Date
Msg-id AANLkTimG36YUrRb48oLPm-dn2_O7mSVvrUFbeZy0Wjvf@mail.gmail.com
Whole thread Raw
In response to 5 pg_toast_temp and pg_temp schemas ?  (Andreas <maps.on@gmx.net>)
List pgsql-admin
On Thu, Oct 7, 2010 at 11:42 PM, Andreas <maps.on@gmx.net> wrote:
>  Hi,
>
> I just recently activated the system objects in pgAdmin.
> Now I'm wondering if it's normal to have 5 pg_toast_temp and 5 pg_temp
> schemas.
>
> It's a PG 8.4.0 server of the OpenSuse distribution that works pretty well.

It's normal to have a few pg_temp and pg_toast_temp schemas,
especially if you have a few backends open.

Josh

pgsql-admin by date:

Previous
From: Ben Kim
Date:
Subject: Re: compare two rows
Next
From: Joy Martin Omello
Date:
Subject: Merge similar databases