On Fri, 26 Mar 2004, Hemapriya wrote: > Hi, > > We have postgresql 7.4.1 running on Mac OS.we are > doing a conversion from mysql to postgres. I'm > importing the table dumps using copy command in > postgres. Copy takes 2 min to import 427938 rows in > one table and at the same time it takes more than 2 > hrs for 2415768 rows.. no of columns are similar in > both the tables. i'm not able to figure out why it is > getting too slower?
Are the field types the same? Indexes on the two tables? For the best chance of a good diagnosis, please post full details of both tables - constraints, indexes, and field types at least. -- Sam Barnett-Cormack Software Developer | Student of Physics & Maths UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings