Tom & Jerry,
Thanks a lot for information!
On Monday (weekends don't have the same load patterns compared to business
days) I will take a look at ` pg_prepared_xacts` that seems to expose Jerry's
suggestion on xacts. Replication slots don't apply to 9.2.X from what I could
investigate so I
Tom Lane writes:
> =?UTF-8?q?Mart=C3=ADn_Fern=C3=A1ndez?= writes:
>
>> We are experiencing some `vacuum` issues with a given table
>> (potentially more). When a manual vacuum runs on the given table it
>> seems that the `vacuum` process is not doing the expected cleanup.
>
>> DETAIL: 113257
=?UTF-8?q?Mart=C3=ADn_Fern=C3=A1ndez?= writes:
> We are experiencing some `vacuum` issues with a given table (potentially
> more). When a manual vacuum runs on the given table it seems that the
> `vacuum` process is not doing the expected cleanup.
> DETAIL: 113257 dead row versions cannot be
Martín Fernández writes:
> *
> Hello,
>
> We are experiencing some `vacuum` issues with a given table
> (potentially more). When a manual vacuum runs on the given table it
> seems that the `vacuum` process is not doing the expected cleanup.
>
> ```
> DETAIL: 113257 dead row versions cannot be
Hello,
We are experiencing some `vacuum` issues with a given table (potentially more).
When a manual vacuum runs on the given table it seems that the `vacuum` process
is not doing the expected cleanup.
```
DETAIL: 113257 dead row versions cannot be removed yet.
```
I've been investigating