Re: [PERFORM] pgsql_tmp( Temporary tablespace)

2012-11-28 Thread Albe Laurenz
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

Re: [PERFORM] pgsql_tmp( Temporary tablespace)

2012-11-28 Thread suhas.basavaraj12
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-Temporar

Re: [PERFORM] pgsql_tmp( Temporary tablespace)

2012-11-28 Thread Albe Laurenz
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 sor