"Nick Fankhauser" <nickf(at)ontko(dot)com> writes:
> So on every primary & foreign key, I have executed this update:
> update table set key = '18105'||key;
> Now, a few queries that used to be swift are very slow,
Could we see the queries? (No, I do not remember your view definitions.)
Offhand I would think that 7.2 is smart enough to deal with this
situation; at least it is supposed to. There might be some cases
involving LIKE/regex matching where it would be overly impressed by
the length of the fixed pattern, but for simple equality joins I
don't see why this change would make any difference.
regards, tom lane