From: | "Erwan DUROSELLE" <EDuroselle(at)seafrance(dot)fr> |
---|---|
To: | <andyj(at)basesys(dot)co(dot)uk>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Rp. : Performance |
Date: | 2002-11-08 09:59:19 |
Message-ID: | 48a44818852be395353de7b38dc650b23dcb8efd@ |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
No, it should be a few seconds.
Could you provide more details? OS, language, is it a single
transaction or not, table description, even maybe your program?
The transaction thing is the most important: if you have
insert ...;
insert ...;
insert ...;
then it is 1 transaction for each insert statement, which is slow.
But if you :
begin transaction
insert ...;
insert ...;
insert ...;
commit;
It should be MUCH faster .
Erwan
>>> "Andy Pearce" <andyj(at)basesys(dot)co(dot)uk> 11/08 10:47 >>>
Hi,
I have a postgresql 7.2.1 db running on a Pentium Pro server with 160mb
ram and scsi drive. I tried to perform a copy to load about 7000
records, using a c program I'd written and it takes about 20 minutes to
complete. each record has 5 field and the total size of each record is
about 56 characters.
Does 20 minutes sound about right for such an action?
Thanks for your help
Andy
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew McMillan | 2002-11-08 10:02:35 | Re: Where is the saved database? |
Previous Message | Andy Pearce | 2002-11-08 09:47:43 | Performance |