Postgres Pro
Downloads
Home   >   mailing lists

Postgresql : pg_temp & pg_toast_temp - Mailing list pgsql-general

From Vishwanath Kummera
Subject Postgresql : pg_temp & pg_toast_temp
Date
Msg-id CAGVcXb1uLMLN_cKyPVeBR3PPpESfSTh2L1wajd0qdX_i6Nmq-Q@mail.gmail.com
Whole thread Raw
Responses Re: Postgresql : pg_temp & pg_toast_temp
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Fwd: Disable autocommit inside dbeaver
Next
From: arun chirappurath
Date:
Subject: Syntax