"Nick Fankhauser" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster