""Dan Austin"" <DAustin(at)au(dot)westfield(dot)com> wrote
> I take it that the file gets renamed almost immediately because we can
> also see writes to the parent directory -- but never see the file itself
> using ls.
I think so.
> What are these files used for? In this particular sample, that file was
> being written to a lot. Perhaps we're running out of memory for some
These files could be generated by several situations to store intermediate
data. For example, hash join and external sort. For sort, if you increase
sort_mem, then you may avoid/alleviate usage of temp file.
In response to
pgsql-admin by date
|Next:||From: Mike C||Date: 2005-12-23 01:34:28|
|Subject: Re: WAL and pg_dump|
|Previous:||From: Dan Austin||Date: 2005-12-23 00:44:42|
|Subject: Re: Pgstat.tmp file activity|