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
