Postgresql : pg_temp & pg_toast_temp

From: Vishwanath Kummera <kvishu83(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Postgresql : pg_temp & pg_toast_temp
Date: 2023-12-07 06:12:00
Message-ID: CAGVcXb1uLMLN_cKyPVeBR3PPpESfSTh2L1wajd0qdX_i6Nmq-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Team
I am seeing there are many schemas created, this is specially when
enabled "CONCURRENTLY" option for refreshing materialized views through
table trigger.

pg_temp_1... pg_temp_30
pg_toast_temp_1... pg_toast_temp_30

If this is by design the temp schemas get created with the "CONCURRENTLY"
option, is there any way to clean-up them automatically?

Thanks,
Vishu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message arun chirappurath 2023-12-07 08:00:39 Syntax
Previous Message Rob Sargent 2023-12-07 03:49:53 Re: Fwd: Disable autocommit inside dbeaver