neeraj kumar <neeru.cse@xxxxxxxxx> writes: > Also curious why query on pg_stat_activity is considering terminated > process ? The short answer to that is that this bug leaves shared memory in a corrupt state. It's not really useful to worry about whether readers should react differently to that --- you could spend endless amounts of time hypothesizing different kinds of corruption and endless amounts of code/cycles trying to work around it. But the right answer is to fix it on the writing side. regards, tom lane