Re: REPEATED INSERT INTO ...

Поиск
Список
Период
Сортировка
От Christoph Haller
Тема Re: REPEATED INSERT INTO ...
Дата
Msg-id 3E5B2AF1.72769E3B@rodos.fzk.de
обсуждение исходный текст
Ответ на REPEATED INSERT INTO ...  (Christoph Haller <ch@rodos.fzk.de>)
Список pgsql-hackers
>
> > The key word REPEATED directs INGRES to encode the INSERT and save
its
> > execution plan when it is first executed. This encoding can account
for
> > significant performance improvements on subsequent executions of the

> > same INSERT.
>
> > What do you others think of it?
>
> You can do that today with PREPARE/EXECUTE; there's no need to invent
> specialized syntax for it.
>
Excellent.
As often, a closer look into the documentation would have saved Tom's
time.
Nevertheless, I think the PREPARE/EXECUTE functionality could definitely

use some more promotion, especially under Performance Tips.
Thanks for your quick reply.

Regards, Christoph




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

Предыдущее
От: cbbrowne@cbbrowne.com
Дата:
Сообщение: Re: Intel drops 64-bit Itanium
Следующее
От: Christoph Haller
Дата:
Сообщение: Re: REPEATED INSERT INTO ... 2nd thread