Tom --
>________________________________ ><...>> >> 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. > > >Thanks, and I'll report back soon. > > >Greg >- > > > > >