Couple of things here. If I read you correctly after you COMMIT the first
part of the transaction goes quickly, but begins to slow down?
HAve you considered removing any indexes you have on the tables prior to
doing such a large insert and creating htem afterwards? It's much cheaper
like that.
Does this happen if you don't run DBMirror (IE local only) copy? I've
never used such large transactions myself before.
--On Monday, March 31, 2003 9:46 AM +0100 Hervé Piedvache <herve@elma.fr>
wrote:
> 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é
> _______________________________________________
> Pgreplication-general mailing list
> Pgreplication-general@gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pgreplication-general
