On 19/03/06, Andreas Pflug <[EMAIL PROTECTED]> wrote:
> Antoine wrote:
> > On 18/03/06, Andreas Pflug <[EMAIL PROTECTED]> wrote:
> >
> >>Antoine wrote:
> >>
> >>>Hi,
> >>>I have enabled the autovacuum daemon, but occasionally still get a
> >>>message telling me I need to run vacuum when I access a
Antoine wrote:
On 18/03/06, Andreas Pflug <[EMAIL PROTECTED]> wrote:
Antoine wrote:
Hi,
I have enabled the autovacuum daemon, but occasionally still get a
message telling me I need to run vacuum when I access a table in
pgadmin.
Bring up the postgresql.conf editor on that server, and watch
On 18/03/06, Andreas Pflug <[EMAIL PROTECTED]> wrote:
> Antoine wrote:
> > Hi,
> > I have enabled the autovacuum daemon, but occasionally still get a
> > message telling me I need to run vacuum when I access a table in
> > pgadmin.
>
> pgAdmin notices a discrepancy between real rowcount and estimat
Antoine wrote:
Hi,
I have enabled the autovacuum daemon, but occasionally still get a
message telling me I need to run vacuum when I access a table in
pgadmin.
pgAdmin notices a discrepancy between real rowcount and estimated
rowcount and thus suggests to run vacuum/analyze; it won't examine
More detail please. It sounds like you running 8.1 and talking about
the integrated autovacuum is that correct? Also, what is the message
specifically from pgadmin?
Matt
Antoine wrote:
Hi,
I have enabled the autovacuum daemon, but occasionally still get a
message telling me I need to run vac
