Обсуждение: n00b autovacuum question
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. Is this normal? Should I use scripts instead of the daemon? Would posting config options make this a much more sensible question? Cheers Antoine -- This is where I should put some witty comment.
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 vacuum when I access a table in > pgadmin. Is this normal? Should I use scripts instead of the daemon? > Would posting config options make this a much more sensible question? > Cheers > Antoine > > -- > This is where I should put some witty comment. > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq >
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 autovacuum rules so it might warn although autovac is running ok. If you're sure autovacuum is running fine, just dismiss the message. It's a hint for newbies that do *not* run vacuum because they don't know what it's good for. Regards Andreas
On 18/03/06, Andreas Pflug <pgadmin@pse-consulting.de> 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 estimated > rowcount and thus suggests to run vacuum/analyze; it won't examine > autovacuum rules so it might warn although autovac is running ok. > > If you're sure autovacuum is running fine, just dismiss the message. I guess that is my problem - I a not sure it is running fine. The process is definitely running but I am getting lots of complaints about performance. This probably has lots to do with crap code and not much to do with the database but I am still searching the maintenance avenue... We have a massive project coming up and I want to go for Postgres (the boss wants Oracle). If I can't get my stuff together I am not sure my arguments will stick... problem is I don't really have the time to experiment properly. Cheers Antoine -- This is where I should put some witty comment.
Antoine wrote: > On 18/03/06, Andreas Pflug <pgadmin@pse-consulting.de> 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 if pgadmin complains. Regards, Andreas
On 19/03/06, Andreas Pflug <pgadmin@pse-consulting.de> wrote: > Antoine wrote: > > On 18/03/06, Andreas Pflug <pgadmin@pse-consulting.de> 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 if pgadmin > complains. Hi, I am not sure I understand what "bring up" means. Could you explain? Thanks Antoine -- This is where I should put some witty comment.