Thread: Vacuum nag !
View Single Post

   
  #1 (permalink)  
Old 04-17-2008, 07:46 PM
Laurent ROCHE
 
Posts: n/a
Default Vacuum nag !

Hi,

I am working on an import of databases, so I keep dropping and re-creating schemas, and then populating tables.

Even, if I do a VACUUM ANALYSE on the entire DB, PG Admin will prompt me to perform a VACUUM when I use one of the tables populated.
Is this normal ?
I would have thought that considering I have already done a VACUUM ANALYSE, I would not need to do it again ! ;-) ... or am I missing something ?

I could check the "don't give me experts advice" in the preferences, but as I am quite a newbee in PG, I feel I need them ! ;-)


Cheers,
L@u
The Computing Froggy








__________________________________________________ _________________________
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses
http://fr.answers.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote