Re: [INTERFACES] Performance

Steven Bradley <sbradley(at)llnl(dot)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