<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div><span>Thanks,</span></div><div><span><br></span></div><div>my version is 8.4. The table contains strings but are not too long...under 100char.</div><div><br></div><div>Thanks,</div><div><br></div><div>Rob</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> 21:19 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>>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></div></div></div></body></html>