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
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
pgsql-interfaces by date
|Next:||From: Kristofer Munn||Date: 1999-06-23 23:31:10|
|Subject: Perl 5 Interface on 6.5 and lo_creat/lo_open problem|
|Previous:||From: Tom Lane||Date: 1999-06-23 23:25:22|
|Subject: Re: [INTERFACES] pgaccess and RH 6.0? |