Re: [GENERAL] VACUUM FULL produce warnings

2004-06-11 Thread Tom Lane
[EMAIL PROTECTED] writes: > if i understand right, after some time vacuum must run without > warnings, but after first warning vacuum print this warnings every > time until reindex. Oh? I was thinking of transient conditions, but it sounds like you have found a way to produce a permanent mismatc

Re: [GENERAL] VACUUM FULL produce warnings

2004-06-11 Thread spied
>> look please http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=253295 TL> I wouldn't worry about it. It's probably due to the fact that we tend TL> to release write lock on system catalogs immediately after updating the TL> catalog, instead of holding the lock till commit. ok, but what is best:

[GENERAL] VACUUM FULL produce warnings

2004-06-10 Thread spied
look please http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=253295 ---(end of broadcast)--- TIP 8: explain analyze is your friend