Re: Statistics mismatch between n_live_tup and actual row count - Mailing list pgsql-general

From tim_wilson
Subject Re: Statistics mismatch between n_live_tup and actual row count
Date
Msg-id 1354850953145-5735602.post@n5.nabble.com
Whole thread Raw
In response to Re: Statistics mismatch between n_live_tup and actual row count  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Statistics mismatch between n_live_tup and actual row count
Re: Statistics mismatch between n_live_tup and actual row count
List 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.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Statistics mismatch between n_live_tup and actual row count
Next
From: Ondrej Ivanič
Date:
Subject: Re: Ubutu 12.04 and PostgreSQL9.2.1