Skip site navigation (1) Skip section navigation (2)

Re: default attstattarget

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: default attstattarget
Date: 2002-07-31 15:57:38
Message-ID: 200207311557.g6VFvcd17316@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Tom Lane will apply this as part of the DROP COLUMN merging.

---------------------------------------------------------------------------

Neil Conway wrote:
> Hi all,
> 
> The attached patch implements the pg_attribute.attstattarget scheme
> discussed on -hackers today. A value of "-1" in this column indicates
> that ANALYZE should use the compiled-in default value. This allows
> pg_dump to record and restore any changes made by the DBA to this
> value using ALTER TABLE ALTER COLUMN SET STATISTICS.
> 
> I made another small behavioral change: IMHO, silently changing
> stat target values we deem inappropriate (< 0, > 1000) without
> warning the user is a bad idea. I changed the < 0 case to be a
> elog(ERROR) and added an elog(WARNING) for the > 1000, and
> documented the upper bound.
> 
> Unless anyone sees any problems, please apply.
> 
> Cheers,
> 
> Neil
> 
> -- 
> Neil Conway <neilconway(at)rogers(dot)com>
> PGP Key ID: DB3C29FC

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-07-31 15:58:24
Subject: Re: default attstattarget
Previous:From: Neil ConwayDate: 2002-07-31 15:01:45
Subject: Re: lock listing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group