From: | Steffen Emil Thorkildsen <steffent(at)ifi(dot)uio(dot)no> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Query precompilation? |
Date: | 2001-02-27 12:25:07 |
Message-ID: | Pine.SOL.4.21.0102271323460.3437-100000@fjorir.ifi.uio.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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.)
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2001-02-27 12:25:15 | Re: Last x records |
Previous Message | martin.chantler | 2001-02-27 11:47:23 | Re: Migrate from MS SQL 6.5 to postgres?? |
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2001-02-27 12:28:43 | Re[4]: Re: [PATCHES] A patch for xlog.c |
Previous Message | Philip Warner | 2001-02-27 10:18:09 | Re: AW: CommitDelay performance improvement |