| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "suhas(dot)basavaraj12 *EXTERN*" <suhas(dot)b(at)verse(dot)in>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: pgsql_tmp( Temporary tablespace) |
| Date: | 2012-11-28 10:27:42 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C208C0C3F7@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Niels Kristian Schjødt | 2012-11-28 12:41:14 | Database design - best practice |
| Previous Message | suhas.basavaraj12 | 2012-11-28 08:37:50 | Re: pgsql_tmp( Temporary tablespace) |