Re: Vacuum not cleaning up rows. - Mailing list pgsql-admin

From SBob
Subject Re: Vacuum not cleaning up rows.
Date
Msg-id ef2d3985-cbb4-4d42-a06a-0c8163dc85a7@www.fastmail.com
Whole thread Raw
In response to Re: Vacuum not cleaning up rows.  (Rui DeSousa <rui@crazybean.net>)
Responses Re: Vacuum not cleaning up rows.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
I do see older backend_start values (from around 6 hours ago). However I am confused as to how a connection to one database in a cluster can prevenr vacuum from cleaning up row versions in a table within another database.   How is that possible since onle one database has access to this table?



On Thu, Jun 20, 2019, at 2:37 PM, Rui DeSousa wrote:

In addition to what others have already stated to check; also check for replication slots.


select * from pg_replication_slots;


pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: Vacuum not cleaning up rows.
Next
From: Tom Lane
Date:
Subject: Re: Vacuum not cleaning up rows.