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?
Does anyone know why there is lot of difference in performance? Any hint is highly appreciated. regards Priya __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly