[EMAIL PROTECTED] (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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to