Vacuumdb - Mailing list pgsql-admin

From Pallav Kalva
Subject Vacuumdb
Date
Msg-id 4166DB45.9060300@deg.cc
Whole thread Raw
List 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



pgsql-admin by date:

Previous
From: "Sharon Schooley"
Date:
Subject: High Availability for PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: Altering column type causes unstable server and data loss.