| From: | Gunnar R|nning <gunnar(at)candleweb(dot)no> |
|---|---|
| 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 16:11:16 |
| Message-ID: | x6g0h0rtqz.fsf@thor.candleweb.no |
| 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:
> 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.
>
Apart from the COPY mentioned by Tom Lane, you should also fo through the
obvious checklist: use -F to disable fsync, drop indexes(if possible), use
several connections(could help if you have multiprossessor system)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-02-27 16:30:35 | Re: Infinate Loop during gmake |
| Previous Message | Hans Jeuken | 2001-02-27 16:11:07 | how to examin the database structure with an sql command |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-02-27 16:13:31 | Re: 'postgres -Q' in test/bench |
| Previous Message | Tom Lane | 2001-02-27 15:56:33 | Re: Query precompilation? |