pgsql: Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table

From: alvherre(at)postgresql(dot)org (Alvaro Herrera)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table
Date: 2006-06-27 03:45:28
Message-ID: 20060627034529.0081F9FA5FC@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table without
analyzing, so that future analyze threshold calculations don't get confused.
Also, make sure we correctly track the decrease of live tuples cause by
deletes.

Per report from Dylan Hansen, patches by Tom Lane and me.

Tags:
----
REL8_1_STABLE

Modified Files:
--------------
pgsql/src/backend/postmaster:
pgstat.c (r1.111.2.3 -> r1.111.2.4)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/pgstat.c.diff?r1=1.111.2.3&r2=1.111.2.4)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2006-06-27 03:46:18 Re: pgsql: Disallow changing/dropping default expression of a SERIAL column
Previous Message Alvaro Herrera 2006-06-27 03:45:16 pgsql: Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table