| From: | pginfo <pginfo(at)t1(dot)unisoftbg(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Very slow insert speed |
| Date: | 2002-08-13 11:19:14 |
| Message-ID: | 3D58EB32.F22E00ED@t1.unisoftbg.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all,
I understand that the problem is by me, but do not have any idea how to
search it.
My configuration:
Dual Athlon MP 1800 MHz,
1 GB RAM,
Mandrake 8.2 with standart postgres install.
I try to insert 5000 records in a flat table with 10 column.
I am working with jdbc for my test.
The speed that I get is max. 20 rows per second inserted !!!
I think it is very low and I make the next step by inserting anoder 5000
rows. The time was 6 rows/sec.
Processor usage was 100% from the first processor and it is the maximum
.
By the next atempt I got one record per second.
How can I detect my problem and what is the normal speed for inserts?
Many thanks in advance.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Theofel | 2002-08-13 11:56:46 | age command |
| Previous Message | Christian Mock | 2002-08-13 10:41:16 | Re: performance with triggers depends on table size? |