DBMirror.pl performance change

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: DBMirror.pl performance change
Date: 2006-01-24 09:06:52
Message-ID: Pine.LNX.4.44.0601241048240.21780-200000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


This attached patch greatly enhances DBMirror.pl performance.
DBMirror.pl was known to have problems when replicating
bytea columns whose data was binary bytes (non printable).
(E.g. tiff, pdf, jpeg, bzip2, etc...)

Minutes, (or hours) for 500kb columns were not unusual.

There has even been an effort by Peter Wilson
(<petew ( at ) yellowhawk ( dot ) co ( dot ) uk>)
to write a C alternative,
which tries to overcome these problems.
However i think another C program is not really needed
at this point.

This patch changes the way extractData parses the data field.

Please have a look at the patch, if you see any potential problems.

Thank you.

P.S.
I also emailed the -sql,-general,-pgreplication lists
with a relevant message.

Steven Singer (the original author) is not reachable.
However i think that some users might already suffer from
poor DBMirror.pl performance.

--
-Achilleus

Attachment Content-Type Size
DBMirror_pl_performance.patch text/plain 2.2 KB

Browse pgsql-patches by date

  From Date Subject
Next Message Joachim Wieland 2006-01-24 09:27:58 Re: [HACKERS] CIDR/INET improvements
Previous Message Marko Kreen 2006-01-24 08:40:51 Re: [PATCHES] postmaster/postgres merge for testing