| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Steffen Emil Thorkildsen <steffent(at)ifi(dot)uio(dot)no> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Query precompilation? |
| Date: | 2001-02-27 15:56:33 |
| Message-ID: | 29309.983289393@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Steffen Emil Thorkildsen <steffent(at)ifi(dot)uio(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-02-27 16:01:36 | Re: Last x records |
| Previous Message | Oliver Elphick | 2001-02-27 15:43:46 | Re: inheritance and partial index: how to override constraints or default_values |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gunnar R|nning | 2001-02-27 16:11:16 | Re: Query precompilation? |
| Previous Message | Peter Eisentraut | 2001-02-27 15:54:39 | Re: SunOS4 |