| From: | Ragnar Hafstað <gnari(at)simnet(dot)is> |
|---|---|
| To: | Costin Manda <siderite(at)madnet(dot)ro> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: very slow after a while... |
| Date: | 2005-04-06 17:01:07 |
| Message-ID: | 1112806867.31874.4.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2005-04-06 at 18:18 +0300, Costin Manda wrote:
> The script does the following thing:
> 1. read the count of rows in two tables from the mssql database
> 2. read the count of rows of the 'mirror' tables in postgres
> these are tables that get updated rarely and have a maximum of 100000
> records together
> 3. if the counts differ, delete from the mirror table everything and
> reinsert everything.
> 4. THEN do the inserts that get updated on error
if you empty the table in step 3, why do you have to test for
the duplicate id error? are there duplicates in the mssql table?
gnari
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Verite | 2005-04-06 17:49:46 | Re: lower function |
| Previous Message | Tom Lane | 2005-04-06 16:59:28 | Re: very slow after a while... |