Re: An Analyze question

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: An Analyze question
Дата
Msg-id 15454.1019489667@sss.pgh.pa.us
обсуждение исходный текст
Ответ на An Analyze question  ("Nick Fankhauser" <nickf@ontko.com>)
Ответы Re: An Analyze question  ("Nick Fankhauser" <nickf@ontko.com>)
Список pgsql-admin
"Nick Fankhauser" <nickf@ontko.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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Nick Fankhauser"
Дата:
Сообщение: An Analyze question
Следующее
От: "Nick Fankhauser"
Дата:
Сообщение: Re: An Analyze question