> > WTF? That should certainly not happen. Have you perhaps got a script > that runs around sending SIGTERM to backends that it thinks are blocking > something? Does anything show up in the postmaster log when this > happens?
No, we have processes that kill IDLE IN TRANSACTIONs ruthlessly, but nothing that kills any other processes. There is an outside chance that this ran at just the same time that a cronjob ran the REINDEX command for the table (unlikely but I am going to shut off the cronjob and try this again).
It does not log an ERROR to the log file; I can wade intio the log and see what else it says but it will take a little while (about 800 megs per hour) to answer that.
