Re: [PERFORM] Insertion puzzles

[Andreas Åkre Solberg]

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

smime.p7s

Description: S/MIME cryptographic signature


PGP.sig

Description: PGP signature