DBMIRROR and INSERT transactions lose time ... - Mailing list pgsql-general

From Hervé Piedvache
Subject DBMIRROR and INSERT transactions lose time ...
Date
Msg-id 200303311046.19717.herve@elma.fr
Whole thread Raw
Responses Re: [Pgreplication-general] DBMIRROR and INSERT transactions lose  (Michael Loftis <mloftis@wgops.com>)
List 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é


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Small file taking up lots of disk space
Next
From: "shreedhar"
Date:
Subject: Fw: Query