Re: slow INSERTS :((

On Sun, Jun 16, 2002 at 07:21:12PM +0530, Varun Kacholia wrote:
> hi ,
> I have migrated from MySql to PostgreSQL and i find that inserts are
> extremly slow.The things which used to be done in 10-15 mins in mysql
> take 1.5 hrs in pgsql(though i expected double or triple the time but
> not 8 times...omg).
> I am using pgsql-7.1 with Redhat linux 7.2
> Tips to increase and improve performace would be appriciated.

Are you using transactions? Putting it all in one transaction should speed
it up considerably.

begin;
inserts...
commit;

Otherwise, shows us the explain for the query.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.