Обсуждение: Re: Issue in autovacuum

Adrian Klaver <adrian.klaver@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

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:tgl@sss.pgh.pa.us]
Sent: Tuesday, March 28, 2017 11:54 PM
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Agarwal, Prateek <prateeka@hpe.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Issue in autovacuum

Adrian Klaver <adrian.klaver@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