Re: Vacuum nag !

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
>

In response to

Responses

Browse pgadmin-support by date

  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 !