Postgres Pro
Downloads
Home   >   mailing lists

Re: reltuples after vacuum and analyze - Mailing list pgsql-performance

From Tom Lane
Subject Re: reltuples after vacuum and analyze
Date
Msg-id 5692.1106678631@sss.pgh.pa.us
Whole thread Raw
In response to reltuples after vacuum and analyze  (Litao Wu <litaowu@yahoo.com>)
Responses Re: reltuples after vacuum and analyze  (Litao Wu <litaowu@yahoo.com>)
List pgsql-performance
Tree view 
Litao Wu <litaowu@yahoo.com> writes:
> reasonable size. But I do not understand
> why "analyze" bloats the table size so
> big??

ANALYZE won't bloat anything.  I suppose you have other processes
inserting or updating data in the table meanwhile.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: reltuples after vacuum and analyze
Next
From: Litao Wu
Date:
Subject: Re: reltuples after vacuum and analyze