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 по дате отправления: