Technical question on PREPARE statements and PLPGSQL cached plans

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Technical question on PREPARE statements and PLPGSQL cached plans
Дата
Msg-id CAKt_ZfvaGwG=M3jujtkshUfP0oK9QMkyfxpDZunzLQqtREau5Q@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Дерево обсуждения 
Hi;

I was wondering....  When is a PREPARE statement planned?  On first
execution?  At the time the PREPARE statement is called?

How does the planner decide what sorts of plans to use when the ideal
plan might change based on future runs?

Is this the same wrt PLPGSQL cached plans?  Or are they planned differently?

Best Wishes,
Chris Travers

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

Предыдущее
От: Durumdara
Дата:
Сообщение: Re: When the Session ends in PGSQL?
Следующее
От: Vincent de Phily
Дата:
Сообщение: Re: How to create "auto-increment" field WITHOUT a sequence object?