Re: [INTERFACES] Performance

Steven Bradley <sbradley@llnl.gov> writes:
> I wanted to use a prepared SQL statement, but it turns out that Postgres
> runs the query through the parser-planner-executor cycle on each iteration.
>  There is no way to prevent this.

> The next thing I though of doing was to "bulk load" several records in one
> INSERT through the use of array processing.  Do any of the Postgres
> interfaces support this?  (by arrays, I don't mean array columns in the
> table).

If you're just inserting literal data, use COPY FROM STDIN instead of
INSERTs.  Much less per-tuple overhead, although it's uglier.
        regards, tom lane