Request a Demo
Home   >   mailing lists

Re: Could ANALYZE estimate bloat? - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Could ANALYZE estimate bloat?
Date
Msg-id 523CD298.5060800@agliodbs.com
Whole thread Raw
In response to Could ANALYZE estimate bloat?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Could ANALYZE estimate bloat?
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: gaussian distribution pgbench
Next
From: "MauMau"
Date:
Subject: Re: UTF8 national character data type support WIP patch and list of open issues.