From: | "Joris Dobbelsteen" <Joris(at)familiedobbelsteen(dot)nl> |
---|---|
To: | "Laurent ROCHE" <laurent_roche(at)yahoo(dot)com> |
Cc: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Vacuum nag ! |
Date: | 2007-01-18 13:24:38 |
Message-ID: | 73427AD314CC364C8DF0FFF9C4D693FF5510@nehemiah.joris2k.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
I have the feeling this could be caused by pgAdmin because it is caching information. Perhaps that a refresh of the database is a workarround.
Unfortunally I'm no expert and I'm not sure about this.
- Joris
>-----Original Message-----
>From: pgadmin-support-owner(at)postgresql(dot)org
>[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of
>Laurent ROCHE
>Sent: donderdag 18 januari 2007 13:55
>To: pgadmin-support(at)postgresql(dot)org
>Subject: [pgadmin-support] 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(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
>
>---------------------------(end of
>broadcast)---------------------------
>TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so
>that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2007-01-18 13:47:43 | Re: Vacuum nag ! |
Previous Message | Laurent ROCHE | 2007-01-18 12:54:44 | Vacuum nag ! |