<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:PMingLiU;
panose-1:2 2 5 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"\@PMingLiU";
panose-1:2 2 5 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:ZH-TW;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:ZH-TW;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"PMingLiU",serif;
mso-fareast-language:ZH-TW;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:3.0cm 2.0cm 3.0cm 2.0cm;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1904827934;
mso-list-type:hybrid;
mso-list-template-ids:-1717269100 67698705 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DA" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">Hi Regina</span><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I’ve enclosed a sample dataset of 31489 rows (enclosed in separate email to Regina) that I hope can serve as a basis for more tests. It’s definitely not top secret, just building polygons for an area in Western Jutland,
Denmark (the total dataset would be for all of Denmark).<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">It should be noted that both the windows and redhat machine are specked with NVMe ssd disks that holds the postgres instance and data.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The windows machine has 64 and the redhat has 128 GB of ram. Both have fairly recent workstation/server-grade cpus.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Windows:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">'POSTGIS="2.3.2 r15302" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 1.11.5, released 2016/07/01" LIBXML="2.9.4" TOPOLOGY RASTER'<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">‘PostgreSQL 9.6.3 on x86_64-pc-mingw64, compiled by gcc.exe (Rev5, Built by MSYS2 project) 4.9.2, 64-bit’<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Red Hat 7.4:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">'POSTGIS="2.4.3 r16312" PGSQL="96" GEOS="3.6.2-CAPI-1.10.2 4d2925d6" SFCGAL="1.2.2" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 1.11.4, released 2016/01/25" LIBXML="2.9.1" LIBJSON="0.11" RASTER'<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">‘PostgreSQL 9.6.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16), 64-bit’<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">On the windows version the statement:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">select <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> st_multi((st_dump(geom)).geom)::geometry(multipolygon,25832) as geom<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> from (<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> select st_union(b.geom) as geom <o:p>
</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> from temp_jonyp.st_union_test b<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> ) foo<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Runs with a ‘Total query runtime: 19.5 secs 18423 rows retrieved.’
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The same statement and data on the redhat machine runs with a ‘Total query runtime: 01:17 minutes 18423 rows retrieved.’<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Both have almost identical execution plans:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Subquery Scan on foo (cost=1428.62..1433.88 rows=1000 width=32)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> Aggregate (cost=1428.62..1428.62 rows=1 width=32)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> Seq Scan on st_union_test b (cost=0.00..1349.89 rows=31489 width=170)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Both have been vacuumed and analyzed beforehand. And max_parallel_workers have been set to 0 on the redhat machine.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I haven’t tried to do a postgis ticket, but let me know if you need that instead.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Kind regards Jonas<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Fra:</b> postgis-users [mailto:postgis-users-bounces@lists.osgeo.org]
<b>På vegne af </b>Regina Obe<br>
<b>Sendt:</b> 24. april 2018 09:07<br>
<b>Til:</b> 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org><br>
<b>Emne:</b> Re: [postgis-users] Performance problems with ST_Union on postgres 9.6, postgis 2.4.3 running on top of Red Hat 7.4<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Couple of things to try<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo2"><![if !supportLists]><span lang="EN-US" style="color:#1F497D"><span style="mso-list:Ignore">1)<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN-US" style="color:#1F497D">Can you reduce the dataset down a bit to the point you can run it in a reasonable amount of time and see differences?<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo2"><![if !supportLists]><span lang="EN-US" style="color:#1F497D"><span style="mso-list:Ignore">2)<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN-US" style="color:#1F497D">On the 2.4.3 plan I see it is running using parallel mode, can you turn off the parallel to rule that out as an issue.
<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US" style="color:#1F497D">Set max_parallel_workers_per_gather = 0;<o:p></o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="color:#1F497D">I don't know what your 2.4.2 was running, but for 2.3, it probably wouldn't run in parallel just because fewer functions were flagged as parallel safe<o:p></o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="color:#1F497D">If you can reduce the set some something reasonable where we can test, I'd be happy to test on various OS/ PostGIS config.<o:p></o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="color:#1F497D">I wouldn't rule out a regression issue on our end.<o:p></o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="color:#1F497D">You can provide a sample on a postgis ticket, if it's not too top secret or just send directly to me.<o:p></o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="color:#1F497D"><a href="http://postgis.net/support/">http://postgis.net/support/</a><o:p></o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="color:#1F497D">Thanks,<o:p></o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="color:#1F497D">Regina<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="margin-left:36.0pt"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> postgis-users [<a href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Jonas Nygaard Pedersen<br>
<b>Sent:</b> Monday, April 23, 2018 11:15 AM<br>
<b>To:</b> 'postgis-users@lists.osgeo.org' <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br>
<b>Subject:</b> [postgis-users] Performance problems with ST_Union on postgres 9.6, postgis 2.4.3 running on top of Red Hat 7.4<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Hi list</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">I'm facing some performance issues when trying to execute the following query on a Red Hat 7.4 machine with Postgres 9.6 (PostgreSQL 9.6.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
20150623 (Red Hat 4.8.5-16), 64-bit) and postgis 2.4.3:</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">select st_multi((st_dump(geom)).geom)::geometry(multipolygon,25832) as geom</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> from (</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> select st_union(b.geom) as geom
</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> from b.gdk_bygning b</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> ) foo;</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Previously the statement above finished in about 3.5 hours but now it seems to go on forever, and I'll cancel it after 3 days.</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">The table contains 5310482 rows and the CREATE TABLE statement looks like this:</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">CREATE TABLE b.gdk_bygning</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">(</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> id_lokalid bigint,</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> objektstatus character varying(4000),</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> registreringfra timestamp(6) without time zone,</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> virkningfra timestamp(6) without time zone,</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> plannoejagtighed double precision,</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> vertikalnoejagtighed double precision,</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> bygninguuid character varying(4000),</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> bygningstype character varying(4000),</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> underminimumbygning character varying(5),</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> status character varying(4000),</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> geom geometry(Polygon,25832)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Indexes:</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">CREATE INDEX gdk_bygning_id_lokalid_idx</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> ON b.gdk_bygning</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> USING btree</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> (id_lokalid);</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">CREATE INDEX sidx_gdk_bygning_geom</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> ON b.gdk_bygning</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> USING gist</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> (geom);</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">I'm not sure where the issue stems from, but from an approximation of when the issue started and near coincidental update from postgis 2.4.1 to 2.4.3, I suspect that the issue is rooted here,
and probably combined with some clumsy settings in my postgresql.conf file.</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Below I have compiled some documentation that I think will be relevant:</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> * the original Postgis install with 'yum',
</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> * the update with 'yum',
</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> * what I think are the relevant settings from my postgresql.conf,
</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> * the query plan for the statement on the current 2.4.3 postgis version,
</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> * and lastly the query plan on a windows machine running postgis 2.3.2 (I'm not able to roll back to 2.4.1 with GEOS 3.5).</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">
</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">The only thing that stands out to me is that the GEOS version is upgraded from 3.5.0 to 3.6.2 but I'm definitely unsure about what's going on and I hope that someone on the list can give me
some advice.</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Regards Jonas
</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">OUTPUT OF 'yum history info' FOR ORIGINAL INSTALL OF POSTGIS:</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Loaded plugins: langpacks, product-id, rhnplugin, search-disabled-repos, subscription-manager</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">This system is receiving updates from RHN Classic or Red Hat Satellite.</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Transaction ID : 7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Begin time : Mon Oct 9 17:56:25 2017</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Begin rpmdb : 1379:99b8afbfabf2cf72ff17087d17a2a1607e29a909</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">End time : 17:56:35 2017 (10 seconds)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">End rpmdb : 1421:bd1fa883ae52216121f1a7c6a2eb06d2d6e36075</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">User : <b031513></span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Return-Code : Success</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Command Line : install postgis24_96.x86_64 postgis24_96-client.x86_64 postgis24_96-devel.x86_64 postgis24_96-utils.x86_64 SFCGAL.x86_64 pgrouting_96.x86_64</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Transaction performed with:</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Installed rpm-4.11.3-25.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Updated subscription-manager-1.19.21-1.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Installed yum-3.4.3-154.el7.noarch @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span>Installed yum-metadata-parser-1.1.4-10.el7.x86_64 @anaconda/7.2<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"> <span lang="EN-US">Installed yum-rhn-plugin-2.0.1-9.el7.noarch @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Packages Altered:</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install CGAL-4.7-1.rhel7.x86_64 @pgdg96</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install CharLS-1.0-5.el7.x86_64 @rhel-x86_64-server-7-epel</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Install SFCGAL-1.2.2-1.rhel7.x86_64 @pgdg96</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install SFCGAL-libs-1.2.2-1.rhel7.x86_64 @pgdg96</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install armadillo-4.320.0-1.el7.x86_64 @rhel-x86_64-server-7-epel</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install arpack-3.1.3-2.el7.x86_64 @rhel-x86_64-server-7-epel</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install atlas-3.10.1-12.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install blas-3.4.2-8.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install boost-atomic-1.53.0-27.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install boost-chrono-1.53.0-27.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install boost-serialization-1.53.0-27.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install cfitsio-3.370-1.el7.x86_64 @rhel-x86_64-server-7-epel</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install freexl-1.0.0i-1.el7.x86_64 @rhel-x86_64-server-7-epel</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install gdal-libs-1.11.4-10.rhel7.x86_64 @pgdg96</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install geos-3.5.0-1.rhel7.x86_64 @pgdg96</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install hdf5-1.8.12-8.el7.x86_64 @rhel-x86_64-server-7-epel</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install lapack-3.4.2-8.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install libdap-3.13.1-2.el7.x86_64 @rhel-x86_64-server-7-epel</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install libgeotiff-1.4.0-1.rhel7.x86_64 @pgdg96</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install libgfortran-4.8.5-16.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install libgta-1.0.4-1.el7.x86_64 @rhel-x86_64-server-7-epel</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install libquadmath-4.8.5-16.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install netcdf-4.3.3.1-5.el7.x86_64 @rhel-x86_64-server-7-epel</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install ogdi-3.2.0-0.19.beta2.el7.x86_64 @rhel-x86_64-server-7-epel</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install openjpeg2-2.1.0-7.el7.x86_64 @rhel-x86_64-server-7-epel</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install perl-Compress-Raw-Zlib-1:2.061-4.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install perl-DBD-Pg-2.19.3-4.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install perl-DBI-1.627-4.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install perl-Data-Dumper-2.145-3.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install perl-IO-Compress-2.061-2.el7.noarch @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install perl-Net-Daemon-0.48-5.el7.noarch @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install perl-PlRPC-0.2020-14.el7.noarch @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install perl-version-3:0.99.07-2.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Install pgrouting_96-2.5.0-1.rhel7.x86_64 @pgdg96</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Install postgis24_96-2.4.0-1.rhel7.x86_64 @pgdg96</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Install postgis24_96-client-2.4.0-1.rhel7.x86_64 @pgdg96</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Install postgis24_96-devel-2.4.0-1.rhel7.x86_64 @pgdg96</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Install postgis24_96-utils-2.4.0-1.rhel7.x86_64 @pgdg96</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install proj-4.8.0-4.el7.x86_64 @rhel-x86_64-server-7-epel</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install unixODBC-2.3.1-11.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install xerces-c-3.1.1-8.el7_2.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">history info</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">OUTPUT OF 'yum history info' FOR THE UPDATE:</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Loaded plugins: langpacks, product-id, rhnplugin, search-disabled-repos, subscription-manager</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">This system is receiving updates from RHN Classic or Red Hat Satellite.</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Transaction ID : 35</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Begin time : Tue Apr 3 11:30:58 2018</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Begin rpmdb : 1748:db6ede4f0b0b9815a1f8704452181b47f0a32796</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">End time : 11:31:04 2018 (6 seconds)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt">End rpmdb : 1749:83a1f934015ebd6db6adc07214b1937477780af4<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt">User : <b031513><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Return-Code : Success</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Command Line : update postgis</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Transaction performed with:</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Installed rpm-4.11.3-25.el7.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Installed subscription-manager-1.19.23-1.el7_4.x86_64 @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Installed yum-3.4.3-154.el7.noarch @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span>Installed yum-metadata-parser-1.1.4-10.el7.x86_64 @anaconda/7.2<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"> <span lang="EN-US">Installed yum-rhn-plugin-2.0.1-9.el7.noarch @rhel-x86_64-server-7</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Packages Altered:</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Dep-Install geos36-3.6.2-3.1.rhel7.x86_64 @pgdg96</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Updated postgis24_96-2.4.1-1.rhel7.x86_64 @pgdg96</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Update 2.4.3-1.rhel7.x86_64 @pgdg96</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Updated postgis24_96-client-2.4.1-1.rhel7.x86_64 @pgdg96</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span>Update 2.4.3-1.rhel7.x86_64 @pgdg96<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"> Updated postgis24_96-devel-2.4.1-1.rhel7.x86_64 @pgdg96<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"> Update 2.4.3-1.rhel7.x86_64 @pgdg96<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"> Updated postgis24_96-utils-2.4.1-1.rhel7.x86_64 @pgdg96<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"> Update 2.4.3-1.rhel7.x86_64 @pgdg96<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt">history info<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"> <o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"> <o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">WHAT I THINK ARE THE RELEVANT OPTIONS IN MY 'postgresql.conf' THAT ARE DIFFERENT FROM THE ONE THAT CAME WITH 9.6 FROM 'pgdg96' REPOSITORY:</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">shared_buffers = 50GB # min 128kB</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> # (change requires restart)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">#huge_pages = try # on, off, or try</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> # (change requires restart)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">#temp_buffers = 8MB # min 800kB</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">#max_prepared_transactions = 0 # zero disables the feature</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> # (change requires restart)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">work_mem = 5GB # min 64kB</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">maintenance_work_mem = 5GB</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">#replacement_sort_tuples = 150000 # limits use of replacement selection sort</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">#autovacuum_work_mem = -1 # min 1MB, or -1 to use maintenance_work_mem</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt">#max_stack_depth = 2MB # min 100kB<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">dynamic_shared_memory_type = posix # the default is the first option</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">effective_io_concurrency = 200 # 1-1000; 0 disables prefetching</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">max_worker_processes = 64 # (change requires restart)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">max_parallel_workers_per_gather = 12 # taken from max_worker_processes</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">seq_page_cost = 1.0 # measured on an arbitrary scale</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">random_page_cost = 2.0 # same scale as above</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">#cpu_tuple_cost = 0.01 # same scale as above</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">#cpu_index_tuple_cost = 0.005 # same scale as above</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">#cpu_operator_cost = 0.0025 # same scale as above</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">parallel_tuple_cost = 0.001 # same scale as above</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">parallel_setup_cost = 100.0 # same scale as above</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">#min_parallel_relation_size = 8MB</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">effective_cache_size = 90GB</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">QUERY PLAN AFTER UPDATE TO POSTGIS 2.4.3 ('POSTGIS="2.4.3 r16312" PGSQL="96" GEOS="3.6.2-CAPI-1.10.2 4d2925d6" SFCGAL="1.2.2" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 1.11.4, released 2016/01/25"
LIBXML="2.9.1" LIBJSON="0.11" RASTER')</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> QUERY PLAN</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">-----------------------------------------------------------------------------------------------------</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Subquery Scan on foo (cost=231732.65..231737.92 rows=1000 width=32)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> -> Aggregate (cost=231732.65..231732.66 rows=1 width=32)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> -> Gather (cost=100.00..218456.45 rows=5310482 width=169)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> Workers Planned: 5</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> -> Parallel Seq Scan on gdk_bygning b (cost=0.00..213045.96 rows=1062096 width=169)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">(5 rows)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">QUERY PLAN ON WINDOWS MACHINE ('POSTGIS="2.3.2 r15302" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 1.11.5, released 2016/07/01" LIBXML="2.9.4" TOPOLOGY RASTER'):</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> QUERY PLAN</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">-------------------------------------------------------------------------------------</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US">Subquery Scan on foo (cost=216558.28..216563.55 rows=1000 width=32)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span>-> Aggregate (cost=216558.28..216558.29 rows=1 width=32)<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> -> Seq Scan on gdk_bygning b (cost=0.00..204498.02 rows=4824102 width=175)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:8.5pt;font-family:"Tahoma",sans-serif;color:#365F91;mso-fareast-language:DA">Jonas Nygaard Pedersen
</span><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#365F91;mso-fareast-language:DA">│Geodataanalytiker</span><span style="font-size:8.5pt;font-family:"Tahoma",sans-serif;color:#365F91;mso-fareast-language:DA">
</span><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#365F91;mso-fareast-language:DA">│</span><span style="font-size:8.5pt;font-family:"Tahoma",sans-serif;color:#365F91;mso-fareast-language:DA">Eff – Effektivisering</span><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#365F91;mso-fareast-language:DA">│</span><span style="font-size:8.5pt;font-family:"Tahoma",sans-serif;color:#365F91;mso-fareast-language:DA">Tel.
7254 5510</span><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#365F91;mso-fareast-language:DA">│</span><span style="font-size:8.5pt;font-family:"Tahoma",sans-serif;color:#365F91;mso-fareast-language:DA">jonyp@sdfe.dk</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"> <o:p></o:p></p>
</div>
</body>
</html>