Thread: output of vacuumdb after upgrade to 7.4.1

output of vacuumdb after upgrade to 7.4.1

From

Olaf Ferger

Date:

01 January 2004, 15:57:54

Hi,

I posted this question via usenet to
comp.databases.postgresql.novice once before but was not
member of the list pgsql-novice. Sorry! I'm worried because
output of command

  vacuumdb --all --analyse

for my databases changed after upgrade to PostgreSQL 7.4.1.

With PostgreSQL 7.3.4 I got:

Vacuuming addr
VACUUM
Vacuuming fertlist
VACUUM
Vacuuming schnitt_cgi
VACUUM
Vacuuming template1
VACUUM

After upgrading to 7.4.1 the same command gives:

vacuumdb: vacuuming database "addr"
vacuumdb: vacuuming database "fertlist"
vacuumdb: vacuuming database "schnitt_cgi"
vacuumdb: vacuuming database "template1"
VACUUM
VACUUM
VACUUM
VACUUM

Does anybody know the reason of this change?

Regards,

  Olaf

--
EOM

Re: output of vacuumdb after upgrade to 7.4.1

From

Tom Lane

Date:

01 January 2004, 17:37:44

Olaf Ferger <mail@olaf-ist-doof.de> writes:
> After upgrading to 7.4.1 the same command gives:

> vacuumdb: vacuuming database "addr"
> vacuumdb: vacuuming database "fertlist"
> vacuumdb: vacuuming database "schnitt_cgi"
> vacuumdb: vacuuming database "template1"
> VACUUM
> VACUUM
> VACUUM
> VACUUM

> Does anybody know the reason of this change?

Looks like the problem is lack of an fflush() in the new C
implementation of vacuumdb.  This is just cosmetic, I suppose,
but should be fixed.  Thanks for the report.

            regards, tom lane