| From: | Dave Page <dpage(at)postgresql(dot)org> |
|---|---|
| To: | Joris Dobbelsteen <Joris(at)familiedobbelsteen(dot)nl> |
| Cc: | Laurent ROCHE <laurent_roche(at)yahoo(dot)com>, pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: Vacuum nag ! |
| Date: | 2007-01-18 13:47:43 |
| Message-ID: | 45AF7A7F.5030207@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Joris Dobbelsteen wrote:
> 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.
You should refresh the table node following vacuum and check that the
estimated rows matches (or is close to) the counted rows. If they are
wildly different, then you need to vacuum (and pgAdmin will most likely
display the hint).
Regards Dave
| From | Date | Subject | |
|---|---|---|---|
| Next Message | William McCoy | 2007-01-18 19:14:05 | Re: mislabeled rpm file |
| Previous Message | Joris Dobbelsteen | 2007-01-18 13:24:38 | Re: Vacuum nag ! |