Vacuumdb

From: Pallav Kalva <pkalva(at)deg(dot)cc>
To: pgsql-admin(at)postgresql(dot)org
Subject: Vacuumdb
Date: 2004-10-08 18:24:05
Message-ID: 4166DB45.9060300@deg.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Everybody,

If i do vacuumdb -z <databasename> daily as a part of my
maintanence, do i have to still vacuum analyze each table in the
database ?. The reason i am asking is that even though i do vacuumdb
daily my stats are not updated properly in pg_class view and the
reltuples values is much higher than the actual records in the table ?
can anyone shed some light on this problem ?

Thanks!
Pallav

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-10-08 19:00:20 Re: Altering column type causes unstable server and data loss.
Previous Message Sharon Schooley 2004-10-08 18:15:48 High Availability for PostgreSQL