Richard Huxton writes:
> Well, both cluster and vacuum full will require a lock on the table. But
> they're more or less doing the same thing, so why the one should work
> and the other not I don't know.
CLUSTER isn't MVCC-safe --- it'll drop rows that are committed dead
even if they are pote
Malcolm McLean wrote:
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.
What I'm still wonde
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.
>>
>> What I'm still wondering about, i
Malcolm McLean wrote:
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 th
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
Malcolm McLean wrote:
Hi,
We are currently having a problem with one of our tables containing far
too many dead rows. The table in question will have a few hundred
thousand inserts and deletes per day and usually builds up quite a large
dead row count that starts to affect the performance of t
Hi,
We are currently having a problem with one of our tables containing far
too many dead rows. The table in question will have a few hundred
thousand inserts and deletes per day and usually builds up quite a large
dead row count that starts to affect the performance of the queries
select from th
