Postgres Pro
Downloads
Home   >   mailing lists

Re: planner question.. - Mailing list pgsql-sql

From Tom Lane
Subject Re: planner question..
Date
Msg-id 11190.1050595832@sss.pgh.pa.us
Whole thread Raw
In response to Re: planner question..  (Rajesh Kumar Mallah <mallah@trade-india.com>)
List pgsql-sql
Tree view 
Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> INFO:  Pages 23923: Changed 36, Empty 0; Tup 178031: Vac 11802, Keep 0, UnUsed 325029.

> Sorry i dont understand the vacuum verbose output throughly , does it looks like
> though ?

Yeah, I think you could do with a VACUUM FULL there ... the table
appears to be less than 50% occupied.
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: analyse question..
Next
From: Manfred Koizar
Date:
Subject: Re: getting rid of "Adding missing FROM-clause entry...."