Welcom & a problem

From: Egyud Csaba <csegyud(at)freemail(dot)hu>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Welcom & a problem
Date: 2002-11-17 21:09:08
Message-ID: 00bf01c28e7d$ab224040$800a0a0a@xxx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everybody!

My name is Csaba, I'm from Hungary. I'm a new member of this list.
I 've gone through the archives but I haven't found too much information on
my problem.

Is there anybody who had ever met such a problem?
(The environment: HP LC2000 NetServer, dual Pentium III 1GHz, 1GB RAM,
2x36GB HP 10000 rpm SCSI HDD)
This is a hardly used industrial purpose web server. The task is to
sychronize the Postgres db to an Win2k based Oracle db. Because I can't see
the Oracle db from the Linux side, I tried to synchronize the data from the
Win2k side via psqlodbc driver. The replicator program is started every
minutes, and generates a long query string to send over to the Postgres . It
contains all the rows to be inserted. In normal circumstances the number of
rows is appr. 8100, but it may be two or three times more when the previous
replications had failed. It isn't too much for such a system, is it?
After one year thay called me to do something because the synchron time
increased to 2(!) days. I can't imagine the reason of it.

Has anybody any idea?
If I'm on the wrong place and sholud ask this question on another list,
please tell me.

Thank you for your help.

Best reguards
Csaba

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.393 / Virus Database: 223 - Release Date: 2002.09.30.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-11-17 23:44:58 Re: [GENERAL] DECLARE CURSOR
Previous Message Tom Lane 2002-11-17 20:12:55 Re: initdb: he_IL is not a valid backend encoding name