On Wed, Dec 29, 2010 at 11:16:23AM -0500, Tom Lane wrote: > Noah Misch <n...@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 <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers