Re: auto vacuum for opentaps

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux