Re: REPEATED INSERT INTO ... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: REPEATED INSERT INTO ...
Date
Msg-id 3284.1046098935@sss.pgh.pa.us
Whole thread Raw
In response to REPEATED INSERT INTO ...  (Christoph Haller <ch@rodos.fzk.de>)
List pgsql-hackers
Christoph Haller <ch@rodos.fzk.de> writes:
> Taken from the Reference Manual
> [REPEATED] INSERT INTO ...

> 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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Justin Clift
Date:
Subject: Re: ILIKE
Next
From: Vince Vielhaber
Date:
Subject: Re: ILIKE