Re: pgAdminII 1.4.12 crash with PostgreSQL 7.3

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

In response to

Browse pgadmin-support by date

  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