Re: [BUGS] BUG #14863: wrong reltuples statistics after vacuumwithout analyze

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [BUGS] BUG #14863: wrong reltuples statistics after vacuumwithout analyze
Дата
Msg-id 20171019235852.wp46idtnulgh5bx2@alvherre.pgsql
обсуждение исходный текст
Ответ на [BUGS] BUG #14863: wrong reltuples statistics after vacuum without analyze  (psuderevsky@gmail.com)
Ответы Re: [BUGS] BUG #14863: wrong reltuples statistics after vacuum without analyze
Список pgsql-bugs
psuderevsky@gmail.com wrote:

> I've faced strange behaviour of statistics state after (auto)VACUUM
> execution without ANALYZE. While ANALYZE operation makes statistics good,
> VACUUM breaks it to inconsistent state.

This may or may not be the same issue Tomas Vondra reported recently; see
https://www.postgresql.org/message-id/94f58897-861b-accf-a9f1-af4be816c0d3@2ndquadrant.com
where he posted a patch to fix the problem.  Would you test that and see
if it solves the problem for you?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: psuderevsky@gmail.com
Дата:
Сообщение: [BUGS] BUG #14863: wrong reltuples statistics after vacuum without analyze
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: [BUGS] pgbouncer-1.7.2-7.rhel6.x86_64.rpm fails to install on AMI