pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql_tmp( Temporary tablespace) 4+ messages / 2 participants [nested] [flat]
* pgsql_tmp( Temporary tablespace) @ 2012-11-28 06:45 suhas.basavaraj12 <suhas.b@verse.in> 2012-11-28 08:28 ` Re: pgsql_tmp( Temporary tablespace) Albe Laurenz <laurenz.albe@wien.gv.at> 0 siblings, 1 reply; 4+ messages in thread From: suhas.basavaraj12 @ 2012-11-28 06:45 UTC (permalink / raw) To: pgsql-performance 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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pgsql_tmp( Temporary tablespace) 2012-11-28 06:45 pgsql_tmp( Temporary tablespace) suhas.basavaraj12 <suhas.b@verse.in> @ 2012-11-28 08:28 ` Albe Laurenz <laurenz.albe@wien.gv.at> 2012-11-28 08:37 ` Re: pgsql_tmp( Temporary tablespace) suhas.basavaraj12 <suhas.b@verse.in> 0 siblings, 1 reply; 4+ messages in thread From: Albe Laurenz @ 2012-11-28 08:28 UTC (permalink / raw) To: suhas.basavaraj12 *EXTERN* <suhas.b@verse.in>; pgsql-performance 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pgsql_tmp( Temporary tablespace) 2012-11-28 06:45 pgsql_tmp( Temporary tablespace) suhas.basavaraj12 <suhas.b@verse.in> 2012-11-28 08:28 ` Re: pgsql_tmp( Temporary tablespace) Albe Laurenz <laurenz.albe@wien.gv.at> @ 2012-11-28 08:37 ` suhas.basavaraj12 <suhas.b@verse.in> 2012-11-28 10:27 ` Re: pgsql_tmp( Temporary tablespace) Albe Laurenz <laurenz.albe@wien.gv.at> 0 siblings, 1 reply; 4+ messages in thread From: suhas.basavaraj12 @ 2012-11-28 08:37 UTC (permalink / raw) To: pgsql-performance 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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pgsql_tmp( Temporary tablespace) 2012-11-28 06:45 pgsql_tmp( Temporary tablespace) suhas.basavaraj12 <suhas.b@verse.in> 2012-11-28 08:28 ` Re: pgsql_tmp( Temporary tablespace) Albe Laurenz <laurenz.albe@wien.gv.at> 2012-11-28 08:37 ` Re: pgsql_tmp( Temporary tablespace) suhas.basavaraj12 <suhas.b@verse.in> @ 2012-11-28 10:27 ` Albe Laurenz <laurenz.albe@wien.gv.at> 0 siblings, 0 replies; 4+ messages in thread From: Albe Laurenz @ 2012-11-28 10:27 UTC (permalink / raw) To: suhas.basavaraj12 *EXTERN* <suhas.b@verse.in>; pgsql-performance 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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2012-11-28 10:27 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2012-11-28 06:45 pgsql_tmp( Temporary tablespace) suhas.basavaraj12 <suhas.b@verse.in> 2012-11-28 08:28 ` Albe Laurenz <laurenz.albe@wien.gv.at> 2012-11-28 08:37 ` suhas.basavaraj12 <suhas.b@verse.in> 2012-11-28 10:27 ` Albe Laurenz <laurenz.albe@wien.gv.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox