Postgres Pro
Downloads
Home   >   mailing lists

slow INSERTS :(( - Mailing list pgsql-general

From Varun Kacholia
Subject slow INSERTS :((
Date
Msg-id 20020616192112.A29546@voxel.cse.iitb.ac.in
Whole thread Raw
Responses Re: slow INSERTS :((  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
 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.
thanks for any help
--
------
Varun
Do not kill time ... else time will kill you

pgsql-general by date:

Previous
From: Darren Ferguson
Date:
Subject: Re: don't know how to get SELECT
Next
From: Martijn van Oosterhout
Date:
Subject: Re: slow INSERTS :((