Re: Statistics mismatch between n_live_tup and actual row count

From: tim_wilson <tim(dot)wilson(at)telogis(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Statistics mismatch between n_live_tup and actual row count
Date: 2012-12-07 02:45:03
Message-ID: 1354848303362-5735593.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<http://postgresql.1045698.n5.nabble.com/file/n5735593/pg_drift.png>

86% of the updates are HOT updates!

The difference between the first and second line of this image above is that
366 updates happened of which 299 where HOT. And a vacuum on the table was
run.
Look at the retuples number change after the vacuum!

Open transactions... how does this impact those numbers?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Statistics-mismatch-between-n-live-tup-and-actual-row-count-tp5059317p5735593.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-12-07 03:01:43 Re: Statistics mismatch between n_live_tup and actual row count
Previous Message Adrian Klaver 2012-12-07 02:26:21 Re: Statistics mismatch between n_live_tup and actual row count