>>> Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I think a large fraction of the writes you're measuring are coming
from
> the file create/unlink operations. It would certainly be important
to
> identify where the bulk of the cost *really* is before we start
> expending effort on a solution.
Any ideas on a good way to gather that information?
Given the temp_buffers space, would it make sense to defer the
creation of the actual file until there is actually a need to spill
data to the disk?
-Kevin