On 09/20/2013 02:17 PM, Stephen Frost wrote:
>> No?
>
> Err, I thought that was one of the things like ANALYZE *did* collect
> through the 'live tuples' number?
Nope. "live tuples" is updated by the stats collector, NOT by analyze.Also, live vs. dead tuples doesn't tell me how
muchfree *space* is
available on pages.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com