Re: pgsql_tmp consuming most of the space.

On Fri, Nov 8, 2024 at 11:51 PM jayesh thakare wrote: > Hi all, > > In one of our production environment.. > > pgsql_tmp is taking about half of the space in FS. > And temp files are from Jan 2024. > > Our data fs is about to reach 98% percent.. > > Kindly suggest us what should be done to resolv

pgsql_tmp consuming most of the space.

Hi all, In one of our production environment.. pgsql_tmp is taking about half of the space in FS. And temp files are from Jan 2024. Our data fs is about to reach 98% percent.. Kindly suggest us what should be done to resolve this issue? pgsql_tmp contains temperorary files during sub query ex