On Nov 13, 2004, at 12:26, vivek singh wrote:
But still, with large volume of data in database the insert operation becomes very slow (ie. to insert 100 records in 5 tables, it takes nearly 3minutes).
What are the performance when you use COPY FROM instead of INSERT ? And have you tested the performance with fsync on and off. -- Andreas Åkre Solberg, UNINETT AS Testnett Contact info and Public PGP Key available on: http://andreas.solweb.no/?account=Work
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
Attachment:
PGP.sig
Description: PGP signature
