Richard Huxton wrote:
> Malcolm McLean wrote:
>> I tested this theory by stopping java applications that were
connected
>> to the database and all other connections that were using
transactions
>> and the full vacuum was still unable to remove the dead rows.
>>
>&g
Richard Huxton wrote:
>> What is causing those dead rows to not get cleared even by a full
>> vacuum? Is there any way keep them low without having to run a
cluster
>> command as that is a locking statement and requires me to close all
java
>> applications that are connecting to that table before r
t to drop to 0. If it
is, I will sacrifice more frequent vacuuming of the other 100 or so
tables in order to keep this one's dead row count low.
We are currently running version 8.1.3 and are in the process of
upgrading to 8.2.3, which is still being tested in development, so I
cannot see how long
