Thanks for your responses! We are not using prepared transactions and not using replication slots as well. We do have a lot of transactions getting created and closed on account of executing the update queries.
Thanks, Prateek -----Original Message----- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Tuesday, March 28, 2017 11:54 PM To: Adrian Klaver <adrian.kla...@aklaver.com> Cc: Agarwal, Prateek <prate...@hpe.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] Issue in autovacuum Adrian Klaver <adrian.kla...@aklaver.com> writes: > On 03/28/2017 03:15 AM, Agarwal, Prateek wrote: >> When I upgrade my db to 9.4.6 (my application remains same and hardly >> any code change w.r.t transaction declarations), it started >> complaining about dead rows below. I am not sure if it is something >> to do with upgrade or not. > So are you using replication slots? Or prepared transactions? Or maybe you just have a really old open transaction? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
