Skip site navigation (1) Skip section navigation (2)

Query precompilation?

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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.)


Responses

pgsql-hackers by date

Next:From: The Hermit HackerDate: 2001-02-27 12:28:43
Subject: Re[4]: Re: [PATCHES] A patch for xlog.c
Previous:From: Philip WarnerDate: 2001-02-27 10:18:09
Subject: Re: AW: CommitDelay performance improvement

pgsql-general by date

Next:From: Richard HuxtonDate: 2001-02-27 12:25:15
Subject: Re: Last x records
Previous:From: martin.chantlerDate: 2001-02-27 11:47:23
Subject: Re: Migrate from MS SQL 6.5 to postgres??

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group