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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
