Re: BUG #14863: wrong reltuples statistics after vacuum without analyze

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: psuderevsky(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14863: wrong reltuples statistics after vacuum without analyze
Date: 2017-10-19 23:58:52
Message-ID: 20171019235852.wp46idtnulgh5bx2@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

psuderevsky(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2017-10-20 08:57:06 Re: pgbouncer-1.7.2-7.rhel6.x86_64.rpm fails to install on AMI
Previous Message psuderevsky 2017-10-19 23:14:24 BUG #14863: wrong reltuples statistics after vacuum without analyze