Обсуждение: pgsql_tmp( Temporary tablespace)
Hi, 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 ? Rgrds Suhas -- View this message in context: http://postgresql.1045698.n5.nabble.com/pgsql-tmp-Temporary-tablespace-tp5733858.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
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
Hi, Can i delete the content of this folder. I have observed couple of times , this folder got cleaned automatically. Which backend process deletes the data from this folder .Any Idea? Rgrds Suhas -- View this message in context: http://postgresql.1045698.n5.nabble.com/pgsql-tmp-Temporary-tablespace-tp5733858p5733863.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
suhas.basavaraj12 wrote: > Can i delete the content of this folder. I have observed couple of times , > this folder got cleaned automatically. These files are in use and you should not delete them. If you need them to go right now, cancel the queries that create temporary files. If there are any leftover when PostgreSQL is shut down (don't know if that can happen), it should be safe to delete them. > Which backend process deletes the data from this folder .Any Idea? I'm not sure, but probably the one that created them. Yours, Laurenz Albe