Re: Postgres performance comments from a MySQL user

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres performance comments from a MySQL user
Дата
Msg-id 6571.1055795728@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgres performance comments from a MySQL user  (Arjen van der Meijden <acm@tweakers.net>)
Ответы Re: Postgres performance comments from a MySQL user  (Arjen van der Meijden <acm@tweakers.net>)
Список pgsql-general
Arjen van der Meijden <acm@tweakers.net> writes:
> Recent postgresql versions (7.3.3 perhaps? Dunno when it got included)
> cache the query-plans on the connection that was used for that
> connection.

There is absolutely no truth to the above statement.  There is no plan
caching (except in plpgsql, which has had it from the beginning).

You can get the effect of plan caching with prepared statements ...
but the OP didn't say anything about using PREPARE ...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: RE : full featured alter table?
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: RE : full featured alter table?