Re: pg_sorttemp files

darcy@druid.net (D'Arcy J.M. Cain) writes:
>> BTW, if you are seeing unreclaimed sorttemp files in a recent release
>> (7.0 or later), I'd like to know about it.  That shouldn't happen,
>> short of a backend crash anyway...

> Well, I had over 6,000 of these files.  This database is about a year old.
> I haven't seen all that many backend crashes in that time.  I guess I better
> keep a close eye on them.

Wow!  Did you happen to note how many distinct PIDs were accounted for?
That would give us some idea of how many lossage events there were.
        regards, tom lane