> > The key word REPEATED directs INGRES to encode the INSERT and save
> > execution plan when it is first executed. This encoding can account
> > 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.
As often, a closer look into the documentation would have saved Tom's
Nevertheless, I think the PREPARE/EXECUTE functionality could definitely
use some more promotion, especially under Performance Tips.
Thanks for your quick reply.
pgsql-hackers by date
|Next:||From: Christoph Haller||Date: 2003-02-25 08:59:44|
|Subject: Re: REPEATED INSERT INTO ... 2nd thread |
|Previous:||From: Antti Haapala||Date: 2003-02-25 07:55:09|
|Subject: Re: How do I change the server encoding?|