<div dir="ltr">Well, first thing just bump up to your relevant latest patch release (<span style="font-size:12.8px;text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">2.3.7) and see if that makes things better.</span><div><span style="font-size:12.8px;text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">It might.</span></div><div><span style="font-size:12.8px;text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Second of all, confirm that the error message is in fact wrong: do those tables causing the message in fact have some non-null/non-empty features?</span></div><div><span style="font-size:12.8px;text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Third of all, attach gdb to the process and run analyze on those suspect tables, and watch what it does. If you don't want to do #3, dump one of the tables and attach it to a ticket. Before doing so, though, load it into a new database and see if it *still* complains during analyze.</span></div><div><span style="font-size:12.8px;text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">P</span></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jul 31, 2018 at 4:43 PM, Nathan Woodrow <span dir="ltr"><<a href="mailto:woodrow.nathan@gmail.com" target="_blank">woodrow.nathan@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Because I was a bit quick on the send this is the version details:<div><br></div><div>PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.9.3, 64-bit POSTGIS="2.3.4 r16009" GEOS="3.6.2-CAPI-1.10.2 4d2925d6" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.1.3, released 2017/20/01" LIBXML="2.9.3" LIBJSON="0.12" (core procs from "2.3.2 r15302" need upgrade) RASTER (raster procs from "2.3.2 r15302" need upgrade)<span class="HOEnZb"><font color="#888888"><br></font></span></div><span class="HOEnZb"><font color="#888888"><div><br></div><div>- Nathan</div></font></span><div><div class="h5"><div><br><div class="gmail_quote"><div dir="ltr">On Wed, Aug 1, 2018 at 9:39 AM Nathan Woodrow <<a href="mailto:woodrow.nathan@gmail.com" target="_blank">woodrow.nathan@gmail.com</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"><div dir="ltr">

<div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial">Hey,</div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial">When I run <span> </span><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">ANALYSE on some of our tables we seem to be getting the following:</span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"> <pre class="m_1238677036668425799gmail-m_-6840226836468183629gmail-code-java" style="margin:0px;padding:0px;max-height:30em;overflow:auto;white-space:pre-wrap;word-wrap:normal;font-size:12px;background-color:rgb(245,245,245);text-decoration-style:initial;text-decoration-color:initial">[2018-08-01 09:20:31] [00000] no non-<span class="m_1238677036668425799gmail-m_-6840226836468183629gmail-code-keyword" style="color:rgb(0,0,145)">null</span>/empty features, unable to compute statistics
[2018-08-01 09:20:31] [00000] no non-<span class="m_1238677036668425799gmail-m_-6840226836468183629gmail-code-keyword" style="color:rgb(0,0,145)">null</span>/empty features, unable to compute statistics</pre> <br></span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">I found an older ticket that was meant to be fixed related to 3D data and large values on the z and m, but from what I can see we don't have any of that in our database.  Dumping the WKT doesn't return any POINTZ or anything like that.</span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Any hints on how to debug this one.  I'm going to check other tables we have but so far 2 are showing it happen and it seems to make the stats not update correctly and given the table is going to be quite large I would like to make sure they stay updated if possible.</span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Regards,</span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Nathan</span></div>

<br></div>
</blockquote></div></div></div></div></div>
<br>______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>