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@svana.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.