Re: FreeBSD upgrade causes performance degredation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: FreeBSD upgrade causes performance degredation
Дата
Msg-id 15012.1004586906@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: FreeBSD upgrade causes performance degredation  ("Peter Schmidt" <peterjs@home.com>)
Ответы Re: FreeBSD upgrade causes performance degredation  ("Peter Schmidt" <peterjs@home.com>)
Список pgsql-admin
"Peter Schmidt" <peterjs@home.com> writes:
> Old function was something like this:
>         SELECT COL1 FROM TABLE WHERE COL2 = SP_FUNCTION(ARG, ARG, ARG, ...)

> The query was modified so that the call to the second function was executed
> as a subselect (and thereby executed only once for all rows in the first
> select?):

>         SELECT COL1 FROM TABLE WHERE COL2 = (SELECT SP_FUNCTION(ARG, ARG,
> ARG...))

This seems like a rather klugy substitute for marking the function
"iscachable".  You might want to read up on that in the CREATE FUNCTION
documentation.

I don't see why an OS change would affect this though; I think you still
have more digging to do to understand the issue.  Did you reinstall
Postgres after the OS update, and if so is it possible you neglected to
do VACUUM ANALYZE after reloading the database?

            regards, tom lane

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

Предыдущее
От: Jeremy Buchmann
Дата:
Сообщение: Re: backup file system
Следующее
От: Tom Lane
Дата:
Сообщение: Re: backup file system