Re: default attstattarget
От | Bruce Momjian |
---|---|
Тема | Re: default attstattarget |
Дата | |
Msg-id | 200207311557.g6VFvcd17316@candle.pha.pa.us обсуждение исходный текст |
Ответ на | default attstattarget (nconway@klamath.dyndns.org (Neil Conway)) |
Список | 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@rogers.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@postgresql.org) -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
В списке pgsql-patches по дате отправления: