On Mon, Jul 21, 2008 at 9:41 AM, Ernesto Eduardo Medina Núñez <eemnpg@xxxxxxxxx> 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.
