Обсуждение: 5 pg_toast_temp and pg_temp schemas ?

Поиск
Список
Период
Сортировка

5 pg_toast_temp and pg_temp schemas ?

От
Andreas
Дата:
  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 ?

От
Josh Kupershmidt
Дата:
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