From 0e3afb327711104fb17be42628c0ca3ce304c197 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 15 Jan 2005 07:53:04 +0000 Subject: [PATCH] Minor improvements in descriptions of recent changes. --- doc/src/sgml/release.sgml | 23 ++++++++++++++--------- 1 file changed, 14 insertions(+), 9 deletions(-) diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index 0be3671931..7d191056a7 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -1,5 +1,5 @@ @@ -648,14 +648,18 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.319 2005/01/15 05:59:44 momjian - Improve optimizer row estimates for non-VACUUMed - tables (Tom) + Improve optimizer rowcount estimates (Tom) - The system now uses the number of blocks in the table to estimate the - number of rows in the table if it has never been - VACUUMed or ANALYZEd. - Previously a fixed value was used in such cases. + Formerly the planner estimated table sizes using the values seen + by the last VACUUM or ANALYZE, + both as to physical table size (number of pages) and number of rows. + Now, the physical table size is obtained directly from the kernel, + and the number of rows is estimated by multiplying the table size + by the row density (rows per page) seen by the last + VACUUM or ANALYZE. This should + produce more reliable estimates in cases where the table size has + changed significantly since the last housekeeping command. @@ -1744,10 +1748,11 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.319 2005/01/15 05:59:44 momjian - Allow PL/pgSQL to understand ELSEIF (Neil) + Accept ELSEIF in PL/pgSQL (Neil) - Previously PL/pgSQL only understood ELSIF. + Previously PL/pgSQL only allowed ELSIF, but many people + are accustomed to spelling this keyword ELSEIF. -- 2.11.0