| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Rahul_Iyer" <rahul_iyer(at)persistent(dot)co(dot)in> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Speeding up operations |
| Date: | 2003-08-13 20:26:03 |
| Message-ID: | 10947.1060806363@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Rahul_Iyer" <rahul_iyer(at)persistent(dot)co(dot)in> writes:
> im on a project using Postgres. The project involves, at times, upto
> 5,000,000 inserts. I was checking the performance of Postgres for 5M inserts
> into a 2 column table (one col=integer, 2nd col=character). I used the
> Prepare... and execute method, so i basically had 5M execute statements and
> 1 prepare statement. Postgres took 144min for this... is there any way to
> improve this performance?
COPY, perhaps. Have you read
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=populate.html
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2003-08-13 21:55:12 | 7.4 beta1 plpgsql regression |
| Previous Message | Rod Taylor | 2003-08-13 19:47:56 | Re: Speeding up operations |