From: | Didier Moens <moensd(at)xs4all(dot)be> |
---|---|
To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: pgAdminII 1.4.12 crash with PostgreSQL 7.3 |
Date: | 2002-12-26 21:51:37 |
Message-ID: | 3E0B79E9.8030401@xs4all.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi,
Dave Page wrote:
>Comments below prefixed DP.
>
>1. Access2K database migration with 1.4.12 is approx. 6 to 8 times
>slower than previous versions (20 minutes -> over two hours), mainly in
>the Foreign Key creation, it seems. I'll check if this is due to pgAdmin
>(1.4.0 -> 1.4.12) or PostgreSQL (7.2.x -> 7.3).
>
>DP: Check you have logging set to none or errors only. The code has had few changes.
>
Yes, I made sure logging was set to none.
I ran my tests again, connecting to a PostgreSQL 7.2.2 server (as to
rule out any luring problems with 7.3) :
When migrating my standard Access2K app (about 20 tables, some 100K
records in total, nothing fancy),
- pgAdminII 1.4.12 took approx. 35 minutes to migrate the tables and
create the indexes, before starting to create the foreign keys. After
another 40 minutes, I stopped the app (as I already knew total execution
time would be more than 2 hours) ;
- pgAdminII 1.4.0 took approx. 19 minutes for tables and indexes, and
another 2 minutes for the foreign keys, totalling 21 minutes.
I could test 1.4.1 and 1.4.2, if you'd like.
Regards,
Didier
--
Didier Moens
-----
RUG/VIB - Dept. Molecular Biomedical Research - Core IT
tel ++32(9)2645309 fax ++32(9)2645348
http://www.dmb.rug.ac.be
From | Date | Subject | |
---|---|---|---|
Next Message | Ana Claudia | 2002-12-27 12:10:18 | FW: Bug on version 7.1.1- Duplicated Rows with same primary key |
Previous Message | Andres Olarte | 2002-12-26 16:34:36 | Problem with tables that have more than 1 field a pkey |