Re: [GENERAL] Issue in autovacuum

2017-03-30 Thread Agarwal, Prateek
] Sent: Tuesday, March 28, 2017 11:54 PM To: Adrian Klaver Cc: Agarwal, Prateek ; pgsql-general@postgresql.org Subject: Re: [GENERAL] Issue in autovacuum Adrian Klaver writes: > On 03/28/2017 03:15 AM, Agarwal, Prateek wrote: >> When I upgrade my db to 9.4.6 (my application remains

Re: [GENERAL] Issue in autovacuum

2017-03-28 Thread Tom Lane
Adrian Klaver 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 >> upgra

Re: [GENERAL] Issue in autovacuum

2017-03-28 Thread Adrian Klaver
On 03/28/2017 03:15 AM, Agarwal, Prateek wrote: I had 9.3.0 previously where auto vacuum was working fine where it was able to reclaim space by removing dead tuples. Version: PostgreSQL 9.4.6 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit When I upg

[GENERAL] Issue in autovacuum

2017-03-28 Thread Agarwal, Prateek
I had 9.3.0 previously where auto vacuum was working fine where it was able to reclaim space by removing dead tuples. Version: PostgreSQL 9.4.6 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit When I upgrade my db to 9.4.6 (my application remains same a