Re: auto vacuum for opentaps

On Mon, Jul 21, 2008 at 9:41 AM, Ernesto Eduardo Medina Núñez
<eemnpg(at)gmail(dot)com> wrote:
> Hi I installed the open source ERP Opentaps which have 802 tables and using
> PostgreSQL as backend, and also filled the tables with demo data.
>
> When I browse the tables using PgAdmin3 I get messages saying that:
> The estimated row count on the table "some_table" deviates significantly
> from the actual row count. You should run vacuum analyze.
>
> So I do it again and again with each table that throws me the message until
> I get tired, then I went to the database's root and click on maintenance,
> vacuum analyze.
> Then a long process begin, after that I continue browsing the tables but I'm
> still getting the messages, so I suppose that I'm not doing the vacuum
> correctly.

What is your default stats target set to? Try increasing it to 50 or
100 for this db and see if the message you're seeing goes away.