From: | Laurent ROCHE <laurent_roche(at)yahoo(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Vacuum nag ! |
Date: | 2007-01-18 12:54:44 |
Message-ID: | 881631.25193.qm@web34406.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Joris Dobbelsteen | 2007-01-18 13:24:38 | Re: Vacuum nag ! |
Previous Message | mike | 2007-01-18 02:36:01 | Re: Copy / Paste problem |