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 |
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 |