dbTalk Databases Forums  

output of vacuumdb after upgrade to 7.4.1

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss output of vacuumdb after upgrade to 7.4.1 in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Olaf Ferger
 
Posts: n/a

Default output of vacuumdb after upgrade to 7.4.1 - 01-01-2004 , 10:56 AM






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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)


Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: output of vacuumdb after upgrade to 7.4.1 - 01-01-2004 , 12:36 PM






Olaf Ferger <mail (AT) olaf-ist-doof (DOT) de> writes:
Quote:
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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.