From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | wsheldah(at)lexmark(dot)com, "Mihai Gheorghiu" <admin(at)planwithtan(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Migrating data from MSAccess |
Date: | 2002-11-22 09:21:08 |
Message-ID: | 200211220921.08075.dev@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thursday 21 Nov 2002 9:26 pm, wsheldah(at)lexmark(dot)com wrote:
> Sounds like you have some on insert triggers that are taking a while to
> validate the data. You probably want to look for ways to speed up the
> triggers, and reduce the amount of validation that has to be done for every
> record if at all possible.
I think Wes is right here, but there are a couple of other things to check:
1. Try updating 1000 rows of a simple dummy table - how long does it take?
2. Same again but wrapped within BEGIN;...COMMIT; so it's one transaction. How
long now?
If both are slow, look to your ODBC. If only the first is slow, try batching
updates into transactions containing somewhere between 100-10,000 rows.
If it turns out PG is slow, we'll need to know more about the database and the
validation etc. you have on it.
--
Richard Huxton
> "Mihai Gheorghiu" <admin(at)planwithtan(dot)com>@postgresql.org on 11/21/2002
> 12:45:26 PM
>
> Sent by: pgsql-general-owner(at)postgresql(dot)org
>
>
> To: <pgsql-general(at)postgresql(dot)org>
> cc:
> Subject: [GENERAL] Migrating data from MSAccess
>
> I'm at the stage to rehearse data migration from MSAccess to PG. The PG db
> actually consolidates 4 MSAccess dbs, with all the possible data
> validations
> and integrity in place. I have some queries over the Access tables which
> then write the data to the ODBC-linked tables in the PG db.
From | Date | Subject | |
---|---|---|---|
Next Message | David Pradier | 2002-11-22 09:55:31 | How to know and change the owner of a table in psql ? |
Previous Message | Tino Wildenhain | 2002-11-22 08:57:05 | Re: Changing the type of a column in an already populated |