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 jim(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net
In response to
pgsql-hackers by date
|Next:||From: Simon Riggs||Date: 2010-12-30 19:04:13|
|Subject: Re: Sync Rep Design|
|Previous:||From: JotaComm||Date: 2010-12-30 17:56:45|
|Subject: Problems with autovacuum and vacuum|