Re: Avoiding rewrite in ALTER TABLE ALTER TYPE

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: Avoiding rewrite in ALTER TABLE ALTER TYPE
Дата
Msg-id 20101229175633.GR25421@fetter.org
обсуждение исходный текст
Ответ на Re: Avoiding rewrite in ALTER TABLE ALTER TYPE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, Dec 29, 2010 at 11:16:23AM -0500, Tom Lane wrote:
> Noah Misch <noah@leadboat.com> writes:
> > ALTER TABLE ALTER TYPE always rewrites the table heap and its indexes.  In some
> > cases, we can determine that doing so is unhelpful, and that the conversion
> > shall always succeed:
> > I wish to replace table rewrites with table verification scans where possible,
> > then skip those verification scans where possible.
> 
> This has been discussed before; have you read the previous threads?

It would help a lot if, in future, you include references to the
previous threads you have in mind rather than simply mention that they
exist.

Saying, in effect, "search the archives with our not-super-great
search technology using keywords you didn't think of," comes off as
pretty dismissive if not downright hostile.

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: pg_streamrecv for 9.1?
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: SSI memory mitigation & false positive degradation