| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | "Samuel J(dot) Sutjiono" <ssutjiono(at)wc-group(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Performance issues with compaq server |
| Date: | 2002-05-08 01:25:27 |
| Message-ID: | 20020508112527.A17584@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Tue, May 07, 2002 at 06:40:32PM -0400, Samuel J. Sutjiono wrote:
> I tried to load data using insert statement to our new database server
> (Compaq DL580, DL590, DL380 using SCSI driver) but it was very very slow.
> The database runs on Red Hat Linux 7.2 and PostgreSQL version 7.1.3
>
> Does anybody know any idea to what cause this problem ? or things that I
> need to look or check (in the config. file)
Put them in a trasaction (begin/commit). Without that, each insert becomes
it's own transaction which is rather expensive. Postgresql 7.2 improves this
a bit but the transaction will help anyway.
HTH,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Snyder | 2002-05-08 02:08:21 | Logging function calls to figure out lo_close log entries? |
| Previous Message | Barry Lind | 2002-05-08 00:54:15 | Re: JDBC - escaping quotes? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-05-08 05:59:46 | Re: db recovery (FATAL 2) |
| Previous Message | postgres | 2002-05-07 23:21:32 | Re: Performance issues with compaq server |