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:16
Message-ID: 20060627034516.BBD329FABE7@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

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.

Modified Files:
--------------
pgsql/src/backend/postmaster:
pgstat.c (r1.130 -> r1.131)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/pgstat.c.diff?r1=1.130&r2=1.131)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2006-06-27 03:45:28 pgsql: Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table
Previous Message Bruce Momjian 2006-06-27 03:43:20 pgsql: Add INCLUDING CONSTRAINTS to CREATE TABLE LIKE.

Browse pgsql-hackers 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 Bruce Momjian 2006-06-27 03:44:19 Re: Inheritance, CREATE TABLE LIKE, and partitioned tables