Re: Postgresql : pg_temp & pg_toast_temp

Vishwanath Kummera writes: >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 Yes, that's by design. There's a sepa

Postgresql : pg_temp & pg_toast_temp

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 "CONCU