Re: Query precompilation?

On Tue, 27 Feb 2001, you wrote:
> 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
> mme. 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!

You should !-)

You can find some valueable tips in the documentation: 
http://www.de.postgresql.org/users-lounge/docs/7.0/user/c4929.htm

> 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.)