Re: Vacuum not cleaning up rows.

From: SBob <sbob(at)quadratum-braccas(dot)com>
To: "Rui DeSousa" <rui(at)crazybean(dot)net>, Keith <keith(at)keithf4(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Vacuum not cleaning up rows.
Date: 2019-06-21 13:51:09
Message-ID: ef2d3985-cbb4-4d42-a06a-0c8163dc85a7@www.fastmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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;
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2019-06-21 14:08:22 Re: Vacuum not cleaning up rows.
Previous Message Rui DeSousa 2019-06-20 18:37:46 Re: Vacuum not cleaning up rows.