DBMIRROR and INSERT transactions lose time ...

From: Hervé Piedvache <herve(at)elma(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Cc: pgreplication-general(at)gborg(dot)postgresql(dot)org
Subject: DBMIRROR and INSERT transactions lose time ...
Date: 2003-03-31 08:46:19
Message-ID: 200303311046.19717.herve@elma.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Who can give us some help with DBMirror ??

We make some test with DBMirror ... for us it's running perfectly ;o)

Only one big trouble ... inserting data in transaction ...
We try to make one transaction with 320 000 inserts ... if the trigger of
DBMirror is not connected we have 100 inserts done in 0.3 sec, with DBMirror
it start quickly but after 1000 insert we lose and lose many time ... 1
second losed by 3000/4000 insert ... after 9 hours we get 45 sec for 100
insert ... :o(

Any idea ? Update ? Patch ? ...

Thanks per advance for your help ... ! :o)

Regards,
--
Hervé

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Johannes Heinz 2003-03-31 10:04:53 problems installing postgre
Previous Message mark carew 2003-03-31 08:38:24 Re: Any recommendations for books on PostgreSQL?