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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-07-31 15:58:24 | Re: default attstattarget |
Previous Message | Neil Conway | 2002-07-31 15:01:45 | Re: lock listing |