Re: Query precompilation? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Query precompilation?
Date
Msg-id 29309.983289393@sss.pgh.pa.us
Whole thread Raw
In response to Query precompilation?  (Steffen Emil Thorkildsen <steffent@ifi.uio.no>)
List pgsql-hackers
Steffen Emil Thorkildsen <steffent@ifi.uio.no> 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Idea for reducing planning time
Next
From: Peter Eisentraut
Date:
Subject: Re: 'postgres -Q' in test/bench