ashok raj escribió:
> Hi ,
>
> is there a way that we could find which procpid or connection that
> has created a particular temporary schema (pg_temp_*) ?.
>
> In one of our db a temporary schema (pg_temp_48) was using more
> than 200GB of disk space and how to find the conne
ashok raj writes:
> is there a way that we could find which procpid or connection that
> has created a particular temporary schema (pg_temp_*) ?.
In 8.3 and up, the number in the pg_temp_N schema name is the same as
the first component of the virtualxids that that session uses. Not
sur
Hi ,
is there a way that we could find which procpid or connection that
has created a particular temporary schema (pg_temp_*) ?.
In one of our db a temporary schema (pg_temp_48) was using more
than 200GB of disk space and how to find the connection which has created
the temp s
