Thread: 5 pg_toast_temp and pg_temp schemas ?

5 pg_toast_temp and pg_temp schemas ?

From
Andreas
Date:
  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.

Re: 5 pg_toast_temp and pg_temp schemas ?

From
Josh Kupershmidt
Date:
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