On Thursday 21 Nov 2002 9:26 pm, wsheldah@lexmark.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@planwithtan.com>@postgresql.org on 11/21/2002
> 12:45:26 PM
>
> Sent by: pgsql-general-owner@postgresql.org
>
>
> To: <pgsql-general@postgresql.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.