Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M8420=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1ZtffX-0004oY-F6
 for pgsql-docs@arkaria.postgresql.org; Tue, 03 Nov 2015 17:46:51 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-docs-owner+M8420=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1ZtffW-0008HB-Rl
 for pgsql-docs@arkaria.postgresql.org; Tue, 03 Nov 2015 17:46:50 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <obartunov@gmail.com>) id 1ZtffW-0008H2-9A
 for pgsql-docs@postgresql.org; Tue, 03 Nov 2015 17:46:50 +0000
Received: from mail-lf0-x22c.google.com ([2a00:1450:4010:c07::22c])
 by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.84) (envelope-from <obartunov@gmail.com>) id 1ZtffS-0003Jg-0P
 for pgsql-docs@postgresql.org; Tue, 03 Nov 2015 17:46:49 +0000
Received: by lfbn126 with SMTP id n126so26973324lfb.2
 for <pgsql-docs@postgresql.org>; Tue, 03 Nov 2015 09:46:44 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:reply-to:in-reply-to:references:from:date:message-id
 :subject:to:cc:content-type;
 bh=03T6K74HZeQIDXHuVm2XINx7AEsG5J/33I8ed+vqcFc=;
 b=LVwiOBaRrWP9BxC3nOWvbdsOBPpovq3lUu0Xa4yw9uPJDxaFoNLPgZtxY0LKDrNkbq
 UhpudFgvB5cymCkJh/hyQsaKnXb11Q0ihbNpYkGd0HxHhcSCsYla2W/p40WO+DflEBXX
 F101o86kaAjLaDe+0HmEtmSdfAiMrFPLb/vst26Whjp5vgme0vvAle8rY3JvUWw51zrn
 mhkchYv/NIYkcFsLwwLjLsoP6ZhkXnpnNg7rrJy1NHS7ELlQfV2wo+tJyyPhOoE43H9+
 fw9iKdQNoE6s0u2na3TxtdpDpYoJHE6i3EEFc8fSyiRPHwfNg9ptwSMpSad/de5uR/Z7
 X3FQ==
X-Received: by 10.112.199.4 with SMTP id jg4mr13227190lbc.59.1446572804423;
 Tue, 03 Nov 2015 09:46:44 -0800 (PST)
MIME-Version: 1.0
Received: by 10.25.156.13 with HTTP; Tue, 3 Nov 2015 09:46:25 -0800 (PST)
Reply-To: obartunov@gmail.com
In-Reply-To: <562E061B.1090809@postgrespro.ru>
References: <1428009501118.85114@postgrespro.ru> <5522E656.4060201@gmx.net>
 <562E061B.1090809@postgrespro.ru>
From: Oleg Bartunov <obartunov@gmail.com>
Date: Tue, 3 Nov 2015 18:46:25 +0100
Message-ID: 
 <CAF4Au4we-vXhe-j9W7gvxKaEg8y_tkWGxZLJRx87qq0xfo8-jA@mail.gmail.com>
Subject: Re: Moving documentation to XML
To: Alexander Lakhin <a.lakhin@postgrespro.ru>
Cc: Peter Eisentraut <peter_e@gmx.net>,
 Luzanov Pavel <PLuzanov@postgrespro.ru>,
 "pgsql-docs@postgresql.org" <pgsql-docs@postgresql.org>
Content-Type: multipart/alternative; boundary=001a11c324b0267e6a0523a67a7c
X-Pg-Spam-Score: -2.7 (--)
List-Archive: <http://archives.postgresql.org/pgsql-docs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-docs.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@postgresql.org>
List-Post: <mailto:pgsql-docs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-docs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
X-Mailing-List: pgsql-docs
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

--001a11c324b0267e6a0523a67a7c
Content-Type: text/plain; charset=UTF-8

On Mon, Oct 26, 2015 at 11:53 AM, Alexander Lakhin <a.lakhin@postgrespro.ru>
wrote:

> Hello, Peter.
>
> I've managed to speed up html generation from xml (make xslthtml) from 32
> min. (in my environment) to 4 min. by modifying slowest XSL templates.
> All my modifications incorporated in a single file
> stylesheet-xhtml-speedup.xsl, which is included in stylesheet.xsl.
> I performed optimization by analyzing output of:
> xsltproc --profile --stringparam pg.version '9.6devel' stylesheet.xsl
> postgres.xml
> Initial statistics:
> number               match                name      mode Calls Tot 100us
> Avg
>
>     0             appendix label.markup
> 23090 90677526   3927
>     1              chapter label.markup
> 28870 39740757   1376
>     2 chunk-all-sections             1289 23845066  18498
>     3                     make.legalnotice.head.links
> 2578 9630258   3735
>     4            indexterm reference   2579 4126513   1600
>     5 html.head             1289 3112534   2414
> ...
> index % time    self  children    called     name
>                 0.479 1326.034     22/23090     toc.line [61]
>                 5.128 1308.245  21944/23090 sect1[label.markup] [13]
>                 3.772 1318.264    850/23090 substitute-markup [15]
>                 1.355 1304.631    274/23090
> figure|table|example[label.markup] [32]
> [0]    47.95  906.775    1.613  23090 appendix[label.markup] [0]
>                 1.613    0.000  23090/23090 autolabel.format [29]
> -----------------------------------------------
>                 5.128 1308.245  24708/28870 sect1[label.markup] [13]
>                 0.479 1326.034    130/28870     toc.line [61]
>                 3.772 1318.264   2112/28870 substitute-markup [15]
>                 1.355 1304.631   1920/28870
> figure|table|example[label.markup] [32]
> [1]    21.01  397.408    1.613  28870 chapter[label.markup] [1]
>                 1.613    0.000  28870/28870 autolabel.format [29]
> -----------------------------------------------
>                 0.164  238.606   1289/1289 process-chunk-element [98]
> [2]    12.61  238.451    0.225   1289 chunk-all-sections [2]
>                 0.225    7.117   1289/1289 process-chunk [86]
> -----------------------------------------------
>                31.125  112.261   1289/2578      html.head [5]
>                96.303   96.726   1289/2578 make.legalnotice.head.links [3]
> [3]     5.09   96.303   96.726   2578 make.legalnotice.head.links [3]
>                96.303   96.726   1289/3867 make.legalnotice.head.links [3]
>                 0.339    0.494   1289/3867 *[object.title.markup.textonly]
> [69]
>                 0.085    0.781   1289/3867 ln.or.rh.filename [116]
>
> -----------------------------------------------
>
>
> Currrent statistics:
> number               match                name      mode Calls Tot 100us
> Avg
>
>     0 chunk-all-sections             1289 5405958   4193
>     1                     make.legalnotice.head.links
>                                                            1289 3159538
>  2451
>     2 html.head             1289 3068417   2380
>     3                         gentext.template 689835 2327761      3
>     4                            l10n.language 564453 1455253      2
>     5 href.target            29881 1344063     44
> ---
> index % time    self  children    called     name
>                 0.136   54.207   1289/1289 process-chunk-element [95]
> [0]    20.40   54.060    0.312   1289 chunk-all-sections [0]
>                 0.312    6.468   1289/1289 process-chunk [67]
> -----------------------------------------------
>                30.684   45.458   1289/1289      html.head [2]
> [1]    11.92   31.595    0.448   1289 make.legalnotice.head.links [1]
>                 0.290    0.403   1289/2578 *[object.title.markup.textonly]
> [71]
>                 0.159    0.828   1289/2578 ln.or.rh.filename [91]
> -----------------------------------------------
>                 0.330   31.617   1289/1289 chunk-element-content [65]
> [2]    11.58   30.684   45.458   1289     html.head [2]
>                31.595    0.448   1289/15462 make.legalnotice.head.links [1]
>                13.441    4.726   5153/15462 href.target [5]
>                 0.290    0.403   5153/15462
> *[object.title.markup.textonly] [71]
>                 0.115    1.576   1289/15462 head.content [99]
>                 0.012    0.000   1289/15462 system.head.content [186]
>                 0.006    0.000   1289/15462 user.head.content [228]
>
> To make sure that result of the transformation is the same, I've compared
> original .html's with .html's generated with modified templates.
> Unfortunately xslt generates random id's, so it's needed to exclude them
> before comparing. I do that with:
> for f in */*.html; do sed -e
> 's/id=\"\(ftn\.\)\?id[a-z][0-9]\+\"/id=\"id\"/g' -i $f ; sed -e
> 's/href=\"[^#]*#\(ftn\.\)\?id[a-z][0-9]\+\"/href=\"#\"/g' -i $f; done
>
>
> So if it's acceptable way to speed up generation of HTML (and maybe some
> other formats), what other steps should we take to move away from SGML?
> If the performance is still not satisfying, please let me know, I'll
> continue to optimize xslt.
> Beside performance issues, I can see some difference in results of 'make
> html' and 'make xslthtml'. For example, see doc/src/sgml/html/spi.html
> (xslt-generated version doesn't contain the lists of functions).
>
> Best regards,
> Alexander


I think this is great result  and it's worth to start moving to xml. I want
to note, that it's 21-th century  and we should think about including
pictures into our documentation, which will greatly improve it. XML makes
this easier.



>
>
>
>
> 06.04.2015 23:02, Peter Eisentraut wrote:
>
>> On 4/2/15 5:22 PM, Luzanov Pavel wrote:
>>
>>> Peter,
>>>
>>>
>>> I found this message in archives:
>>>
>>>
>>> http://www.postgresql.org/message-id/flat/519C3D99.9000304@gmx.net#519C3D99.9000304@gmx.net
>>>
>>>
>>> and, as you recommend, tested a speed of building docs on a fresh Ubuntu
>>> installation.
>>>
>>> 50sec for make html
>>> and 14min 50sec for make xslthtml
>>> 17 times slower!
>>>
>>>
>>> Is it still a main stopper for moving to XML?
>>>
>> Yes :)
>>
>>
>>
>>
>
>
> --
> Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-docs
>
>

--001a11c324b0267e6a0523a67a7c
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><br><div class=3D"gmail_extra"><br><div class=3D"gmail_quo=
te">On Mon, Oct 26, 2015 at 11:53 AM, Alexander Lakhin <span dir=3D"ltr">&l=
t;<a href=3D"mailto:a.lakhin@postgrespro.ru" target=3D"_blank">a.lakhin@pos=
tgrespro.ru</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello, =
Peter.<br>
<br>
I&#39;ve managed to speed up html generation from xml (make xslthtml) from =
32 min. (in my environment) to 4 min. by modifying slowest XSL templates.<b=
r>
All my modifications incorporated in a single file stylesheet-xhtml-speedup=
.xsl, which is included in stylesheet.xsl.<br>
I performed optimization by analyzing output of:<br>
xsltproc --profile --stringparam pg.version &#39;9.6devel&#39; stylesheet.x=
sl postgres.xml<br>
Initial statistics:<br>
number=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0match=C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 name=C2=A0 =C2=A0 =C2=A0 m=
ode Calls Tot 100us Avg<br>
<br>
=C2=A0 =C2=A0 0=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0appendix lab=
el.markup<br>
23090 90677526=C2=A0 =C2=A03927<br>
=C2=A0 =C2=A0 1=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 chapter lab=
el.markup<br>
28870 39740757=C2=A0 =C2=A01376<br>
=C2=A0 =C2=A0 2 chunk-all-sections=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
 =C2=A01289 23845066=C2=A0 18498<br>
=C2=A0 =C2=A0 3=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0make.legalnotice.head.links<br>
2578 9630258=C2=A0 =C2=A03735<br>
=C2=A0 =C2=A0 4=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 indexterm referenc=
e=C2=A0 =C2=A02579 4126513=C2=A0 =C2=A01600<br>
=C2=A0 =C2=A0 5 html.head=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A012=
89 3112534=C2=A0 =C2=A02414<br>
...<br>
index % time=C2=A0 =C2=A0 self=C2=A0 children=C2=A0 =C2=A0 called=C2=A0 =C2=
=A0 =C2=A0name<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.479 1326.034=C2=
=A0 =C2=A0 =C2=A022/23090=C2=A0 =C2=A0 =C2=A0toc.line [61]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 5.128 1308.245=C2=
=A0 21944/23090 sect1[label.markup] [13]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 3.772 1318.264=C2=
=A0 =C2=A0 850/23090 substitute-markup [15]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 1.355 1304.631=C2=
=A0 =C2=A0 274/23090 figure|table|example[label.markup] [32]<br>
[0]=C2=A0 =C2=A0 47.95=C2=A0 906.775=C2=A0 =C2=A0 1.613=C2=A0 23090 appendi=
x[label.markup] [0]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 1.613=C2=A0 =C2=A0 =
0.000=C2=A0 23090/23090 autolabel.format [29]<br>
-----------------------------------------------<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 5.128 1308.245=C2=
=A0 24708/28870 sect1[label.markup] [13]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.479 1326.034=C2=
=A0 =C2=A0 130/28870=C2=A0 =C2=A0 =C2=A0toc.line [61]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 3.772 1318.264=C2=
=A0 =C2=A02112/28870 substitute-markup [15]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 1.355 1304.631=C2=
=A0 =C2=A01920/28870 figure|table|example[label.markup] [32]<br>
[1]=C2=A0 =C2=A0 21.01=C2=A0 397.408=C2=A0 =C2=A0 1.613=C2=A0 28870 chapter=
[label.markup] [1]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 1.613=C2=A0 =C2=A0 =
0.000=C2=A0 28870/28870 autolabel.format [29]<br>
-----------------------------------------------<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.164=C2=A0 238.606=
=C2=A0 =C2=A01289/1289 process-chunk-element [98]<br>
[2]=C2=A0 =C2=A0 12.61=C2=A0 238.451=C2=A0 =C2=A0 0.225=C2=A0 =C2=A01289 ch=
unk-all-sections [2]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.225=C2=A0 =C2=A0 =
7.117=C2=A0 =C2=A01289/1289 process-chunk [86]<br>
-----------------------------------------------<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A031.125=C2=A0 112.261=
=C2=A0 =C2=A01289/2578=C2=A0 =C2=A0 =C2=A0 html.head [5]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A096.303=C2=A0 =C2=A09=
6.726=C2=A0 =C2=A01289/2578 make.legalnotice.head.links [3]<br>
[3]=C2=A0 =C2=A0 =C2=A05.09=C2=A0 =C2=A096.303=C2=A0 =C2=A096.726=C2=A0 =C2=
=A02578 make.legalnotice.head.links [3]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A096.303=C2=A0 =C2=A09=
6.726=C2=A0 =C2=A01289/3867 make.legalnotice.head.links [3]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.339=C2=A0 =C2=A0 =
0.494=C2=A0 =C2=A01289/3867 *[object.title.markup.textonly] [69]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.085=C2=A0 =C2=A0 =
0.781=C2=A0 =C2=A01289/3867 ln.or.rh.filename [116]<br>
<br>
-----------------------------------------------<br>
<br>
<br>
Currrent statistics:<br>
number=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0match=C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 name=C2=A0 =C2=A0 =C2=A0 m=
ode Calls Tot 100us Avg<br>
<br>
=C2=A0 =C2=A0 0 chunk-all-sections=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
 =C2=A01289 5405958=C2=A0 =C2=A04193<br>
=C2=A0 =C2=A0 1=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0make.legalnotice.head.links<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A01289 3159538=
=C2=A0 =C2=A02451<br>
=C2=A0 =C2=A0 2 html.head=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A012=
89 3068417=C2=A0 =C2=A02380<br>
=C2=A0 =C2=A0 3=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0gentext.template 689835 2327761=C2=A0 =C2=A0=
 =C2=A0 3<br>
=C2=A0 =C2=A0 4=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 l10n.language 564453 1455253=C2=A0 =
=C2=A0 =C2=A0 2<br>
=C2=A0 =C2=A0 5 href.target=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 29881 =
1344063=C2=A0 =C2=A0 =C2=A044<br>
---<br>
index % time=C2=A0 =C2=A0 self=C2=A0 children=C2=A0 =C2=A0 called=C2=A0 =C2=
=A0 =C2=A0name<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.136=C2=A0 =C2=A05=
4.207=C2=A0 =C2=A01289/1289 process-chunk-element [95]<br>
[0]=C2=A0 =C2=A0 20.40=C2=A0 =C2=A054.060=C2=A0 =C2=A0 0.312=C2=A0 =C2=A012=
89 chunk-all-sections [0]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.312=C2=A0 =C2=A0 =
6.468=C2=A0 =C2=A01289/1289 process-chunk [67]<br>
-----------------------------------------------<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A030.684=C2=A0 =C2=A04=
5.458=C2=A0 =C2=A01289/1289=C2=A0 =C2=A0 =C2=A0 html.head [2]<br>
[1]=C2=A0 =C2=A0 11.92=C2=A0 =C2=A031.595=C2=A0 =C2=A0 0.448=C2=A0 =C2=A012=
89 make.legalnotice.head.links [1]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.290=C2=A0 =C2=A0 =
0.403=C2=A0 =C2=A01289/2578 *[object.title.markup.textonly] [71]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.159=C2=A0 =C2=A0 =
0.828=C2=A0 =C2=A01289/2578 ln.or.rh.filename [91]<br>
-----------------------------------------------<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.330=C2=A0 =C2=A03=
1.617=C2=A0 =C2=A01289/1289 chunk-element-content [65]<br>
[2]=C2=A0 =C2=A0 11.58=C2=A0 =C2=A030.684=C2=A0 =C2=A045.458=C2=A0 =C2=A012=
89=C2=A0 =C2=A0 =C2=A0html.head [2]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A031.595=C2=A0 =C2=A0 =
0.448=C2=A0 =C2=A01289/15462 make.legalnotice.head.links [1]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A013.441=C2=A0 =C2=A0 =
4.726=C2=A0 =C2=A05153/15462 href.target [5]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.290=C2=A0 =C2=A0 =
0.403=C2=A0 =C2=A05153/15462 *[object.title.markup.textonly] [71]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.115=C2=A0 =C2=A0 =
1.576=C2=A0 =C2=A01289/15462 head.content [99]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.012=C2=A0 =C2=A0 =
0.000=C2=A0 =C2=A01289/15462 system.head.content [186]<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.006=C2=A0 =C2=A0 =
0.000=C2=A0 =C2=A01289/15462 user.head.content [228]<br>
<br>
To make sure that result of the transformation is the same, I&#39;ve compar=
ed original .html&#39;s with .html&#39;s generated with modified templates.=
<br>
Unfortunately xslt generates random id&#39;s, so it&#39;s needed to exclude=
 them before comparing. I do that with:<br>
for f in */*.html; do sed -e &#39;s/id=3D\&quot;\(ftn\.\)\?id[a-z][0-9]\+\&=
quot;/id=3D\&quot;id\&quot;/g&#39; -i $f ; sed -e &#39;s/href=3D\&quot;[^#]=
*#\(ftn\.\)\?id[a-z][0-9]\+\&quot;/href=3D\&quot;#\&quot;/g&#39; -i $f; don=
e<br>
<br>
<br>
So if it&#39;s acceptable way to speed up generation of HTML (and maybe som=
e other formats), what other steps should we take to move away from SGML?<b=
r>
If the performance is still not satisfying, please let me know, I&#39;ll co=
ntinue to optimize xslt.<br>
Beside performance issues, I can see some difference in results of &#39;mak=
e html&#39; and &#39;make xslthtml&#39;. For example, see doc/src/sgml/html=
/spi.html (xslt-generated version doesn&#39;t contain the lists of function=
s).<br>
<br>
Best regards,<br>
Alexander</blockquote><div><br></div><div>I think this is great result=C2=
=A0 and it&#39;s worth to start moving to xml. I want to note, that it&#39;=
s 21-th century=C2=A0 and we should think about including pictures into our=
 documentation, which will greatly improve it. XML makes this easier. <br><=
/div><div><br>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin=
:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><br>
<br>
<br>
<br>
06.04.2015 23:02, Peter Eisentraut wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
On 4/2/15 5:22 PM, Luzanov Pavel wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
Peter,<br>
<br>
<br>
I found this message in archives:<br>
<br>
<a href=3D"http://www.postgresql.org/message-id/flat/519C3D99.9000304@gmx.n=
et#519C3D99.9000304@gmx.net" rel=3D"noreferrer" target=3D"_blank">http://ww=
w.postgresql.org/message-id/flat/519C3D99.9000304@gmx.net#519C3D99.9000304@=
gmx.net</a><br>
<br>
<br>
and, as you recommend, tested a speed of building docs on a fresh Ubuntu<br=
>
installation.<br>
<br>
50sec for make html<br>
and 14min 50sec for make xslthtml<br>
17 times slower!<br>
<br>
<br>
Is it still a main stopper for moving to XML?<br>
</blockquote>
Yes :)<br>
<br>
<br>
<br>
</blockquote>
<br>
</div></div><br><br>
--<br>
Sent via pgsql-docs mailing list (<a href=3D"mailto:pgsql-docs@postgresql.o=
rg" target=3D"_blank">pgsql-docs@postgresql.org</a>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-docs" rel=3D"noreferrer=
" target=3D"_blank">http://www.postgresql.org/mailpref/pgsql-docs</a><br>
<br></blockquote></div><br></div></div>

--001a11c324b0267e6a0523a67a7c--