Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table - Mailing list pgsql-committers

From alvherre@postgresql.org (Alvaro Herrera)
Subject pgsql: Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table
Date
Msg-id 20060627034529.0081F9FA5FC@postgresql.org
Whole thread Raw
Responses Re: pgsql: Clamp last_anl_tuples to n_live_tuples, in  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-committers
Tree view 
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)

pgsql-committers by date:

Previous
From: alvherre@postgresql.org (Alvaro Herrera)
Date:
Subject: pgsql: Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Disallow changing/dropping default expression of a SERIAL column