<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div><span>Ok thanks,</span></div><div><span><br></span></div><div>Is it dangerous to delete toast tables?</div><div><br></div><div><br></div><div><br></div><div style="font-size: 10pt; font-family: arial, helvetica, sans-serif; "><div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "><font size="2" face="Arial"><hr size="1"><b><span style="font-weight:bold;">Von:</span></b> Greg Williamson <gwilliamson39@yahoo.com><br><b><span style="font-weight: bold;">An:</span></b> Robert Buckley <robertdbuckley@yahoo.com>; "postgis-users@postgis.refractions.net" <postgis-users@postgis.refractions.net>; PostGIS Users Discussion <postgis-users@postgis.refractions.net><br><b><span style="font-weight: bold;">Gesendet:</span></b> 22:43 Donnerstag, 22.September 2011 <br><b><span style="font-weight:
bold;">Betreff:</span></b> Re: [postgis-users] where did pg_toast,pg_toast_temp1 come from?<br></font><br>Rob --<br><br><...><br>><br>>Thanks,<br>><br>>my version is 8.4. The table contains strings but are not too long...under 100char.<br>><br>>Thanks,<br>><br><br><br>According to <<a href="http://trac.osgeo.org/postgis/wiki/DevWikiPostGISCoding" target="_blank">http://trac.osgeo.org/postgis/wiki/DevWikiPostGISCoding</a>>:<br><br>"All PostGIS objects are "varlena", they don't have a fixed size. ..."<br><br>So maybe you got some large geometries that triggered TOAST processing ?<br><br>Greg W.<br><br>><br>>________________________________<br>>Von: Greg Williamson <<a ymailto="mailto:gwilliamson39@yahoo.com" href="mailto:gwilliamson39@yahoo.com">gwilliamson39@yahoo.com</a>><br>>An: Robert Buckley <<a ymailto="mailto:robertdbuckley@yahoo.com"
href="mailto:robertdbuckley@yahoo.com">robertdbuckley@yahoo.com</a>>; "<a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>" <<a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>>; PostGIS Users Discussion <<a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>>Gesendet: 21:19 Donnerstag, 22.September 2011 <br>>Betreff: Re: [postgis-users] where did pg_toast,pg_toast_temp1 come from?<br>><br>>Rob -- <br>><br>>>Hi,<br>>><br>>><br>>>when I left work today these pg_toast tables were not in my database. when I looked later ther were.<br>>><br>>><br>>>Can anyone tell me where they came
from and why they are automatically created in every database?<br>>><br>><br>><br>>You don't state what version of postgres this happens on, but in general TOAST tables are created by the system to hold long compressed values (typically text aka varlena tables). I think you can turn this facility off, but in general postgres will try to take very long strings, for example, and compress them, putting them into a toast table to that the row size of the original table doesn't grow excessively. See, for example, <br>> <<a href="http://www.postgresql.org/docs/9.0/interactive/storage-toast.html" target="_blank">http://www.postgresql.org/docs/9.0/interactive/storage-toast.html</a>><br>><br>>So I suspect what happened is that someone entered some long text values and postgres created the toast tables to handle these long strings.<br>><br>>HTH,<br>><br>>Greg
Williamson<br>><br>><br>><br>>_______________________________________________<br>>postgis-users mailing list<br>><a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br>><br>>><br><br><br></div></div></div></body></html>