<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>I doubt this browsing issue has anything to do with
'random_page_cost'... Why on earth would it? This is a PostgreSQL
setting, to which the ESRI software is essentially completely
oblivious. <br>
</p>
<p>The ESRI software just sits on top of this PostgreSQL
infrastructure, it essentially doesn't do anything different than
QGIS does, just watch the SQL statements coming in in PgAdmin.<br>
</p>
<p>I have been running ArcMap and latest ArcGIS Pro versions against
up to PostgreSQL 13 / PostGIS 3.1 mostly fine using ArcGIS "Query
Layers", including browsing data from the catalogs in ArcMap and
Pro, with a postgresql config optimized for SSD (both run against
SATA and NVMe raid), and an OpenStreetMap "planet" size database
on an HPZ840 dual CPU (S2) workstation that I managed to recently
acquire second hand from a refurbished hardware supplier.<br>
</p>
<p>Yes, I have a few bug cases open at ESRI support, including one
related to a very specific serious performance issue of one of the
geoprocessing tools, but none of that related to
'random_page_cost'. Also, as soon as you start upgrading the
technical challenges to OpenStreetMap "planet" size databases,
ArcGIS certainly isn't the only software out there running into
issues here and there, QGIS does too, as well as many other
software packages. Handling > 500M record tables, just requires
thought, whatever toolbox you happen to open...</p>
<p>Marco<br>
</p>
<div class="moz-cite-prefix">Op 22-5-2021 om 12:51 schreef Darafei
"Komяpa" Praliaskouski:<br>
</div>
<blockquote type="cite"
cite="mid:CAC8Q8tLeHDTdJy9LyBx31xxeG4POJUHrMJn09e=gk-aPFjw2bQ@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">ESRI has multiple issues in itself that are
terrible to debug.
<div><br>
<div>A client of ours fights a bug where it can't browse
tables once you set random_page_cost to the SSD values of
1.1 instead of 4. So I guess if we're using a bit more index
scan than usual there may be an unknown problem that does
not show itself with QGIS and GeoServer.</div>
<div><br>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Mon, May 17, 2021 at 10:05
PM Regina Obe <<a href="mailto:lr@pcorp.us"
moz-do-not-send="true">lr@pcorp.us</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Has
anyone tried running PostgreSQL 13 with PostGIS 3.1 and using
ArcGIS Pro<br>
2.7 for editing?<br>
<br>
I gather from this that it is not supported?<br>
<br>
<a
href="https://desktop.arcgis.com/en/system-requirements/latest/database-requirements-postgresql.htm"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://desktop.arcgis.com/en/system-requirements/latest/database-requiremen<br>
ts-postgresql.htm</a><br>
<br>
I think for ST_Geometry type (ESRI's version) I would need to
stick with<br>
PostgreSQL 12 since they probably don't have PostgreSQL 13
binaries.<br>
<br>
But I assume even for that case PostgreSQL 12 / PostGIS 3.1
should work fine<br>
as it's not reliant on ESRI's libs.<br>
<br>
Thanks,<br>
Regina<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank"
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">Darafei "Komяpa" Praliaskouski<br>
OSM BY Team - <a href="http://openstreetmap.by/"
target="_blank" moz-do-not-send="true">http://openstreetmap.by/</a><br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</body>
</html>