Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: DBMirror_pl_performance.patch
Description: text/plain (2.2 KB)

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group