Rép. : Performance

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@basesys.co.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