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 03:29:13
Message-ID: 1354850953145-5735602.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks for the reply Tom,

will try and construct test case. Have been unable to replicate in a simple
test the sort of updates that the table out in the wild is seeing, so may
impact that issue of vacuum finding unrepresentative sample, maybe.

Will try harder!

When you say recent releases, does that include 8.4?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Statistics-mismatch-between-n-live-tup-and-actual-row-count-tp5059317p5735602.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 Ondrej Ivanič 2012-12-07 03:47:22 Re: Ubutu 12.04 and PostgreSQL9.2.1
Previous Message Tom Lane 2012-12-07 03:19:22 Re: Statistics mismatch between n_live_tup and actual row count