Re: [PERFORM] VACUUM problems with 7.4

[Tom Lane]

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.  Whether it has yet looked at this table is
not relevant, because the system has no way to know whether it might
decide to do so later.

regards, tom lane

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [PERFORM] VACUUM problems with 7.4

[Neil Conway]

[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 an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly