Re: Statistics mismatch between n_live_tup and actual row count

Поиск
Список
Период
Сортировка
От tim_wilson
Тема Re: Statistics mismatch between n_live_tup and actual row count
Дата
Msg-id 1354848303362-5735593.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: Statistics mismatch between n_live_tup and actual row count  (Adrian Klaver <adrian.klaver@gmail.com>)
Ответы Re: Statistics mismatch between n_live_tup and actual row count
Список 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.

В списке pgsql-general по дате отправления: