Skip site navigation (1) Skip section navigation (2)

Re: postgres copy command very slow.

From: Sam Barnett-Cormack <s(dot)barnett-cormack(at)lancaster(dot)ac(dot)uk>
To: Hemapriya <priyam_1121(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: postgres copy command very slow.
Date: 2004-03-27 02:58:24
Message-ID: Pine.LNX.4.58.0403270257280.15225@short.lancs.ac.uk (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

pgsql-admin by date

Next:From: listasDate: 2004-03-27 03:12:23
Subject: Re: License for PostgreSQL for commercial purpose
Previous:From: Ben KimDate: 2004-03-26 22:49:30
Subject: Can I make PostgreSql namespace case-insensitive?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group