From 6601f3bdf5956f673ed0d828f2ea9754d9907a1e Mon Sep 17 00:00:00 2001 From: David Fetter Date: Mon, 22 Feb 2010 15:42:17 +0000 Subject: [PATCH] Fixed 'Feature of the Week' per Robert Haas git-svn-id: file:///Users/dpage/pgweb/svn-repo/trunk@2632 8f5c7a92-453e-0410-a47f-ad33c8a6b003 --- .../en/community/weeklynews/pwn20100221.html | 13 +++++++------ 1 file changed, 7 insertions(+), 6 deletions(-) diff --git a/portal/template/en/community/weeklynews/pwn20100221.html b/portal/template/en/community/weeklynews/pwn20100221.html index 1a1aae54..680a0459 100644 --- a/portal/template/en/community/weeklynews/pwn20100221.html +++ b/portal/template/en/community/weeklynews/pwn20100221.html @@ -61,12 +61,13 @@ RHQ 3.0.0.B02 Systems management and monitoring software released.

PostgreSQL 9.0 Feature of the Week

You can now control the behavior of distinct values per column using -ALTER TABLE...ALTER COLUMN...SET STATISTICS DISTINCT. Positive -numbers are assumed to be the number of distinct values, 0 tells the -planner to use the results from ANALYZE, and negative numbers (which -should be between -1 and 0, cause the planner to estimate the number -of distinct values as the estimated number of rows multiplied by the -absolute value of the number. +ALTER TABLE...ALTER COLUMN...SET (parameter=value,...) where parameter +can be one of n_distinct and n_distinct_inherited. Positive numbers +are assumed to be the number of distinct values, 0 tells the planner +to use the results from ANALYZE, and negative numbers (which should be +between -1 and 0, cause the planner to estimate the number of distinct +values as the estimated number of rows multiplied by the absolute +value of the number.

PostgreSQL Jobs for February

-- 2.39.5