Re: Query on pg_stat_activity table got stuck - Mailing list pgsql-admin

From Tom Lane
Subject Re: Query on pg_stat_activity table got stuck
Date
Msg-id 28335.1557504838@sss.pgh.pa.us
Whole thread Raw
In response to Re: Query on pg_stat_activity table got stuck  (neeraj kumar <neeru.cse@gmail.com>)
Responses Re: Query on pg_stat_activity table got stuck
Re: Query on pg_stat_activity table got stuck
List pgsql-admin
neeraj kumar <neeru.cse@gmail.com> 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



pgsql-admin by date:

Previous
From: neeraj kumar
Date:
Subject: Re: Query on pg_stat_activity table got stuck
Next
From: neeraj kumar
Date:
Subject: Re: Query on pg_stat_activity table got stuck