Re: [BUGS] BUG #14863: wrong reltuples statistics after vacuumwithout analyze - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: [BUGS] BUG #14863: wrong reltuples statistics after vacuumwithout analyze
Date
Msg-id 20171019235852.wp46idtnulgh5bx2@alvherre.pgsql
Whole thread Raw
In response to [BUGS] BUG #14863: wrong reltuples statistics after vacuum without analyze  (psuderevsky@gmail.com)
Responses Re: [BUGS] BUG #14863: wrong reltuples statistics after vacuum without analyze  (Pavel Suderevsky <psuderevsky@gmail.com>)
List 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 by date:

Previous
From: psuderevsky@gmail.com
Date:
Subject: [BUGS] BUG #14863: wrong reltuples statistics after vacuum without analyze
Next
From: Magnus Hagander
Date:
Subject: Re: [BUGS] pgbouncer-1.7.2-7.rhel6.x86_64.rpm fails to install on AMI