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 to sponsor work on a patch that makes those operations as fast as just adding a new column. -- Jim C. Nasby, Database Architect j...@nasby.net 512.569.9461 (cell) http://jim.nasby.net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers