[HACKERS] Query precompilation?

[Steffen Emil Thorkildsen]

Hi,

I have an application which has an queue of data it has to insert into
a table in a local database. the insert-queries syntax is all the same,
and the values are the only thing that differs. The insert-query looks
like this:

 INSERT INTO "table" VALUES(a, b, c, d, e, f, g, h)

...but I cannot insert more than 200/sec, and that is much too slow for
me. Are there ways to precompile a sqlquery or do other tricks to get the
*fastest* insertion-rate, since the data-queue is growing faster than
200/sec... I don't care about integrity etc!

I'm using PostgreSQL 7.0.3, RH 6.2 Linux 2.2.4, and the pq library with
gcc.


Regards,

Steffen E. Thorkildsen

(PS! Please reply to my e-mail aswell.)

Re: [HACKERS] Query precompilation?

[Tom Lane]

Steffen Emil Thorkildsen [EMAIL PROTECTED] writes:
 I have an application which has an queue of data it has to insert into
 a table in a local database. the insert-queries syntax is all the same,
 and the values are the only thing that differs. The insert-query looks
 like this:

  INSERT INTO "table" VALUES(a, b, c, d, e, f, g, h)

 ...but I cannot insert more than 200/sec, and that is much too slow for
 me.

Consider using COPY FROM STDIN instead ...

regards, tom lane