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 much free *space* is available on pages. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers