<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Thanks Paul!<div><br></div><div>Really sorry I did not find it myself, shame on me. :(</div><div><br></div><div><br></div><div><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div><div><span class="Apple-style-span" style="border-collapse: separate; font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-weight: normal; font-style: normal; "><div style="color: rgb(0, 0, 0); ">Javier de la Torre</div><div style="color: rgb(0, 0, 0); font-size: 11px; "><a href="http://twitter.com/jatorre/"><font class="Apple-style-span" color="#000000">@jatorre</font></a></div><div style="color: rgb(0, 0, 0); "><br></div><div style="color: rgb(0, 0, 0); "><b>Vizzuality</b></div><div style="color: rgb(0, 0, 0); font-size: 10px; ">148 Lafayette St. PH, New York, 10013,USA</div><div style="color: rgb(0, 0, 0); font-size: 10px; ">Hortaleza 48 1, 28004,Madrid,Spain</div><div style="color: rgb(0, 0, 0); font-size: 10px; ">+1 347 320 7715</div><div style="color: rgb(0, 0, 0); font-size: 10px; ">+34 689 41 4420</div><div style="font-size: 10px; "><a href="http://www.vizzuality.com/"><font class="Apple-style-span" color="#000000">www.vizzuality.com</font></a></div></div><div><font class="Apple-style-span" size="2"><a href="http://twitter.com/vizzuality">@vizzuality</a></font></div><div><br></div><div><br></div></span></div></div></div></div></span></div></span></span><br class="Apple-interchange-newline">
</div>
<br><div><div>On Sep 19, 2011, at 1:06 PM, Paul Ramsey wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Javier,<br>You can get a fast, imprecise extent from st_estimated_extent. We<br>should update/change it to use the index top page, but for now it uses<br>the index stats, which means it is sometimes slightly underdetermined,<br>so you might need to grow it by 10-25% depending on your use case.<br>Paul<br><br>On Mon, Sep 19, 2011 at 9:29 AM, Javier de la Torre<br><<a href="mailto:jatorre@vizzuality.com">jatorre@vizzuality.com</a>> wrote:<br><blockquote type="cite">Hi all,<br></blockquote><blockquote type="cite">I need to calculate the extent of a full table. My understanding is that<br></blockquote><blockquote type="cite">this function will do a full scan of the table to calculate it. Is it<br></blockquote><blockquote type="cite">possible to get the extent of the table from the index somehow so that is<br></blockquote><blockquote type="cite">not needed to scan the full table? I also dont need it very precise if that<br></blockquote><blockquote type="cite">helps in any way.<br></blockquote><blockquote type="cite">Thanks!<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Javier de la Torre<br></blockquote><blockquote type="cite">@jatorre<br></blockquote><blockquote type="cite">Vizzuality<br></blockquote><blockquote type="cite">148 Lafayette St. PH, New York, 10013,USA<br></blockquote><blockquote type="cite">Hortaleza 48 1, 28004,Madrid,Spain<br></blockquote><blockquote type="cite">+1 347 320 7715<br></blockquote><blockquote type="cite">+34 689 41 4420<br></blockquote><blockquote type="cite"><a href="http://www.vizzuality.com">www.vizzuality.com</a><br></blockquote><blockquote type="cite">@vizzuality<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">_______________________________________________<br></blockquote><blockquote type="cite">postgis-users mailing list<br></blockquote><blockquote type="cite"><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br></blockquote><blockquote type="cite"><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>http://postgis.refractions.net/mailman/listinfo/postgis-users<br></div></blockquote></div><br></div></body></html>