<[EMAIL PROTECTED]> writes:
> But it was not this bad in 7.3 as far as i understand.
No, I believe this behavior is present in any recent release of
PostgreSQL.
-Neil
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send a
> Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
>> I am sure there is no transaction open with the table banner_stats2. Still VACUUM
>> FULL does
>> not seems to effective in removing the
>> dead rows.
>
> That is not the issue --- the limiting factor is what is your oldest open
> transaction,
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
> I am sure there is no transaction open with the table banner_stats2.
> Still VACUUM FULL does not seems to effective in removing the
> dead rows.
That is not the issue --- the limiting factor is what is your oldest
open transaction, period. Wheth
I am sure there is no transaction open with the table banner_stats2.
Still VACUUM FULL does not seems to effective in removing the
dead rows.
Can any one please help?
Regds
mallah
tradein_clients=# VACUUM FULL verbose banner_stats2 ;
INFO: vacuuming "public.banner_stats2"
INFO: "banner_stats
