Re: interpret vacuum verbose output

From: Shankar K <shan0075(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: interpret vacuum verbose output
Date: 2003-06-06 17:07:41
Message-ID: 20030606170741.2150.qmail@web21102.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks tom that was very useful.

just wondering what could be "Keep 0, UnUsed 205434"
refer here. does that any of it impact in evaluvating
the vaccum frequecy.

thanks,
Shankar

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Shankar K <shan0075(at)yahoo(dot)com> writes:
> > I'm trying to evaluate the frequecy to run vacuum
> > analyze on key tables. so if anyone could help me
> to
> > interpret the output of vacuum analyze verbose
> output
> > that would be great.
>
> > INFO: Removed 55448 tuples in 2367 pages.
> > CPU 0.04s/0.11u sec elapsed 0.41 sec.
> > INFO: Pages 11266: Changed 4, Empty 0; Tup 231:
> Vac
> > 55448, Keep 0, UnUsed 205434.
>
> This says that you have 231 live tuples versus 55448
> that were removed ---
> in other words, less than one-half of one percent of
> your table was
> current data. You need to vacuum this table a LOT
> more often than
> you are doing.
>
> You will need a VACUUM FULL and a REINDEX to get the
> table and index
> physical sizes down to something reasonable, after
> which a more rigorous
> schedule of plain vacuums ought to keep things in
> shape.
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org
> so that your
> message can get through to the mailing list cleanly

__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ben Schneider 2003-06-06 20:12:50 Help! Error when calling a function
Previous Message Kris Kiger 2003-06-06 16:42:27 Disk I/O Monitoring