suhas.basavaraj12 wrote:
> This folde( Temporary tablespace) is getting filled and size increases
in
> the day where there lots of sorting operations.But after some times
the data
> in the is deleted automatically . Can any one explain what is going
on ?
Must be temporary files created by the sorting operations.
If a sort, hash or similar operation is estimated to need
more than work_mem if done in memory, data will be dumped
to disk instead.
If you want to avoid that, you need to increase work_mem
(but make sure you don't run out of memory).
Yours,
Laurenz Albe