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