On Fri, 26 Mar 2004, Hemapriya wrote:
> 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.
Software Developer | Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
In response to
pgsql-admin by date
|Next:||From: listas||Date: 2004-03-27 03:12:23|
|Subject: Re: License for PostgreSQL for commercial purpose|
|Previous:||From: Ben Kim||Date: 2004-03-26 22:49:30|
|Subject: Can I make PostgreSql namespace case-insensitive?|