Re: REPEATED INSERT INTO ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: REPEATED INSERT INTO ...
Date: 2003-02-24 15:02:15
Message-ID: 3284.1046098935@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Christoph Haller <ch(at)rodos(dot)fzk(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Vince Vielhaber 2003-02-24 15:13:06 Re: ILIKE
Previous Message Justin Clift 2003-02-24 14:39:20 Re: ILIKE