Postgres Pro
Downloads
Home   >   mailing lists

Re: Avoiding rewrite in ALTER TABLE ALTER TYPE - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Avoiding rewrite in ALTER TABLE ALTER TYPE
Date
Msg-id A9A390FA-8EEE-4378-A2FC-D6E86B6E3894@nasby.net
Whole thread Raw
In response to Re: Avoiding rewrite in ALTER TABLE ALTER TYPE  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
On Dec 29, 2010, at 10:14 PM, Robert Haas wrote:
> +1 for trying to optimize these cases (but maybe after we optimize the
> varchar -> text and varchar(less) -> varchar(more) cases to skip the
> scan altogether).

+1 on getting the obvious cases of varchar and numeric done first; we run into those a lot at work and would be willing
tosponsor work on a patch that makes those operations as fast as just adding a new column. 
--
Jim C. Nasby, Database Architect                   jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net

pgsql-hackers by date:

Previous
From: JotaComm
Date:
Subject: Problems with autovacuum and vacuum
Next
From: Simon Riggs
Date:
Subject: Re: Sync Rep Design