<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Actually not easily, though a function could be written to do that. Just checking the PC_MemSize and comparing w/ 8K is a rough/ready way.</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">P</div> <div id="bloop_sign_1391795881581951232" class="bloop_sign"><div><br></div><span style="font-family:helvetica,arial;font-size:13px"></span>-- <br>Paul Ramsey<br>http://cleverelephant.ca<div>http://postgis.net</div></div> <br><p style="color:#A0A0A8;">On February 7, 2014 at 12:10:27 AM, Roger Bedell (<a href="mailto://rbedell@coordinatesolutions.com">rbedell@coordinatesolutions.com</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div>
<title></title>
<div dir="ltr">Good morning Paul,
<div>Is there any way to tell if your data got Toasted? (who made
up that acronym?). I used 400 point patches, and everything seems
fine so far, but I only have billions, not trillions of
points.</div>
<div>Roger</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Thu, Feb 6, 2014 at 7:21 PM, Paul
Ramsey <span dir="ltr"><<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">
<div class="im">
<div>
<blockquote type="cite" style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:start;font-style:normal;font-weight:normal;line-height:normal;text-transform:none;font-size:13px;white-space:normal;font-family:Helvetica,Arial;word-spacing:0px">
<span style="font-family:Helvetica,Arial">> Since we store
patches with practically no extra information next to them in the
tuple, just reading the PC_MemSize (I think that’s the function) of
the patch gives an idea of storage you can use to bump up your
patch size to close to the maximum (8kb). </span><span><br>
<br>
Is there a way we could communicate from the db to
drivers.pgpointcloud.writer an automatic toast'able patch size
based on this info?<span> </span></span></blockquote>
</div>
</div>
<p>Yes, no, maybe so. You already have the core info (before
looking at data) in your pipeline. The schema gives you an implicit
point size. All you don’t know is the compression ratio, and until
you start compressing actual data you don’t know that.</p>
<div>
<div class="im">
<div>
<blockquote type="cite" style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:start;font-style:normal;font-weight:normal;line-height:normal;text-transform:none;font-size:13px;white-space:normal;font-family:Helvetica,Arial;word-spacing:0px">
<span>> You can also recompile your database with a higher page
size if you’re feeling hacky.<span> </span><br>
<br>
Is there any possibility that pg could be improved to allow tables
of varying page sizes? I suppose increasing the page size generally
across an entire database could cause some unforeseen
pathologies.<span> </span></span></blockquote>
</div>
</div>
<p>Next you’ll want to start f’ing with the gravitational constant.
If you want to make the experiment, the page size is just a
#define, and it might actually be a configure option even. It does
cover the whole database though, variable page sizes aren’t on.</p>
<p><span class="HOEnZb"><font color="#888888">P.</font></span></p>
<p><span class="HOEnZb"><font color="#888888"><br></font></span></p>
</div>
</div>
<br>
_______________________________________________<br>
pgpointcloud mailing list<br>
<a href="mailto:pgpointcloud@lists.osgeo.org">pgpointcloud@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/pgpointcloud" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/pgpointcloud</a><br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br></div>
--<br>
Roger Bedell<br>
Coordinate Solutions Inc.<br></div>
</div></div></span></blockquote></body></html>