<DD>page's own description: The Atlas of Living Australia provides tools to enable users of biodiversity information to find, access, combine and visualise data on Australian plants and animals

            <DT><A HREF="http://mail.iplantcollaborative.org/mailman/listinfo/bien-db" name="http://mail.iplantcollaborative.org/mailman/listinfo/bien-db" ADD_DATE="1351012861" LAST_CHARSET="us-ascii"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Bien-db Info Page</A><a name="Bien-db Info Page" href="#Bien-db Info Page" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.biodiversitycollectionsindex.org/static/citing.html" name="http://www.biodiversitycollectionsindex.org/static/citing.html" ADD_DATE="1360673202" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Biodiversity Collections Index</A><a name="Biodiversity Collections Index" href="#Biodiversity Collections Index" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="https://pods.iplantcollaborative.org/wiki/dashboard.action" name="https://pods.iplantcollaborative.org/wiki/dashboard.action" ADD_DATE="1317679822" ICON_URI="https://pods.iplantcollaborative.org/wiki/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://pods.iplantcollaborative.org/wiki/favicon.ico" style="margin-right: 0.5em;"/>Dashboard - iPlant Collaborative Wiki</A><a name="Dashboard - iPlant Collaborative Wiki" href="#Dashboard - iPlant Collaborative Wiki" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.youtube.com/watch?v=LemPnZn54Kw#t=2709s" name="http://www.youtube.com/watch?v=LemPnZn54Kw#t=2709s" ADD_DATE="1374160719" ICON_URI="http://s.ytimg.com/yts/img/favicon_32-vflWoMFGx.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://s.ytimg.com/yts/img/favicon_32-vflWoMFGx.png" style="margin-right: 0.5em;"/>Enquist Lab in action on PBS NOVA &lt; PBS Nova - Fractals - Hunting the Hidden Dimension. - YouTube</A><a name="Enquist Lab in action on PBS NOVA &lt; PBS Nova - Fractals - Hunting the Hidden Dimension. - YouTube" href="#Enquist Lab in action on PBS NOVA &lt; PBS Nova - Fractals - Hunting the Hidden Dimension. - YouTube" style="margin-left: 0.5em;">&para;</a>

<DD>page's own description: Mysteriously beautiful fractals are shaking up the world of mathematics and deepening our understanding of nature. A fractal is &quot;a rough or fragmented geomet...

            <DT><A HREF="http://www.fgdc.gov/standards/projects/FGDC-standards-projects/vegetation/NVCS_V2_FINAL_2008-02.pdf" name="http://www.fgdc.gov/standards/projects/FGDC-standards-projects/vegetation/NVCS_V2_FINAL_2008-02.pdf" ADD_DATE="1367819868" ICON_URI="http://www.fgdc.gov/favicon.ico"><img width="16" height="16" src="http://www.fgdc.gov/favicon.ico" style="margin-right: 0.5em;"/>National Vegetation Classification Standard (Version 2)</A><a name="National Vegetation Classification Standard (Version 2)" href="#National Vegetation Classification Standard (Version 2)" style="margin-left: 0.5em;">&para;</a>

<DD>-

contains field names for plots data

            <DT><A HREF="http://phylodiversity.net/phylomatic/" name="http://phylodiversity.net/phylomatic/" ADD_DATE="1372279279" ICON_URI="http://phylodiversity.net/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://phylodiversity.net/favicon.ico" style="margin-right: 0.5em;"/>Phylomatic (v3)</A><a name="Phylomatic (v3)" href="#Phylomatic (v3)" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.geog.leeds.ac.uk/projects/rainfor/" name="http://www.geog.leeds.ac.uk/projects/rainfor/" ADD_DATE="1317679297" ICON_URI="http://www.rainfor.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.rainfor.org/favicon.ico" style="margin-right: 0.5em;"/>RAINFOR</A><a name="RAINFOR" href="#RAINFOR" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://brunalab.org/apps/" name="http://brunalab.org/apps/" ADD_DATE="1370068544" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>smartphone apps for field biologists</A><a name="smartphone apps for field biologists" href="#smartphone apps for field biologists" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.nceas.ucsb.edu/phone_list" name="http://www.nceas.ucsb.edu/phone_list" ADD_DATE="1390760071" ICON_URI="http://www.nceas.ucsb.edu/files/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.nceas.ucsb.edu/files/favicon.ico" style="margin-right: 0.5em;"/>Phone List | NCEAS</A><a name="Phone List | NCEAS" href="#Phone List | NCEAS" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://support.nceas.ucsb.edu/rt/" name="http://support.nceas.ucsb.edu/rt/" ADD_DATE="1319052273" ICON_URI="http://support.nceas.ucsb.edu/rt/NoAuth/images/favicon.png"><img width="16" height="16" src="http://support.nceas.ucsb.edu/rt/NoAuth/images/favicon.png" style="margin-right: 0.5em;"/>support</A><a name="support" href="#support" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://webchat.nceas.ucsb.edu/?channels=nceas" name="http://webchat.nceas.ucsb.edu/?channels=nceas" ADD_DATE="1317857134" ICON_URI="http://webchat.nceas.ucsb.edu/images/favicon.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://webchat.nceas.ucsb.edu/images/favicon.png" style="margin-right: 0.5em;"/>Connect - NCEAS Web IRC</A><a name="Connect - NCEAS Web IRC" href="#Connect - NCEAS Web IRC" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.ia.ucsb.edu/pa/display.aspx?pkey=3045" name="http://www.ia.ucsb.edu/pa/display.aspx?pkey=3045" ADD_DATE="1371772726" ICON_URI="http://www.ia.ucsb.edu/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.ia.ucsb.edu/favicon.ico" style="margin-right: 0.5em;"/>&quot;New Moore Foundation Funding Supports UCSB Ecology Synthesis Center Embarking on a New Era &quot; - UC Santa Barbara News Release</A><a name="&quot;New Moore Foundation Funding Supports UCSB Ecology Synthesis Center Embarking on a New Era &quot; - UC Santa Barbara News Release" href="#&quot;New Moore Foundation Funding Supports UCSB Ecology Synthesis Center Embarking on a New Era &quot; - UC Santa Barbara News Release" style="margin-left: 0.5em;">&para;</a>

<DD>page's own description: New Moore Foundation Funding Supports UCSB  Ecology Synthesis Center Embarking on a New Era 

you definitely want to turn this *off* in all cases! joins are written in a particular order for a reason (because the programmer knows which indexes are available and therefore which order is correct). the query planner is not smarter than the programmer!

incorrect query plans are an ongoing bug in Postgres, because it does not support index hints and by default does not follow the join order. specifically, Postgres often does the following things in query plans which should normally never be done:

* uses an in-memory hash join when an index is available (because it incorrectly thinks that accessing an index on disk will be too slow)

* sorts *both* input tables before performing a merge join (if really no index is available, a hash join is much faster than two sorts and a merge join)

* does the entire join sequence in the opposite order (because it incorrectly thinks that the last table in the join will be filtered to fewer rows than the first table, and ignores the programmer's join order)

* joins a pair of tables in the wrong order (the smaller table should be iterated over, with an index or hash lookup being used for the larger table, not vice versa)

SET enable_seqscan = off;

SET join_collapse_limit = 1; -- turn it off

SET enable_sort = off;

SET enable_hashjoin = off; -- better to keep this on if possible

                          text_var2 = PG_EXCEPTION_DETAIL,

                          text_var3 = PG_EXCEPTION_HINT;

"

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/sql-createdomain.html" name="http://www.postgresql.org/docs/9.3/static/sql-createdomain.html" ADD_DATE="1386257057" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.3: CREATE DOMAIN</A><a name="PostgreSQL: Documentation: 9.3: CREATE DOMAIN" href="#PostgreSQL: Documentation: 9.3: CREATE DOMAIN" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/sql-createview.html" name="http://www.postgresql.org/docs/9.3/static/sql-createview.html" ADD_DATE="1393552021" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.3: CREATE VIEW</A><a name="PostgreSQL: Documentation: 9.3: CREATE VIEW" href="#PostgreSQL: Documentation: 9.3: CREATE VIEW" style="margin-left: 0.5em;">&para;</a>

<DD>&quot;Simple views are automatically updatable: the system will allow INSERT, UPDATE and DELETE statements to be used on the view in the same way as on a regular table.&quot; (this is only available in 9.3+)

                <DT><A HREF="http://compnetworking.about.com/cs/wireless80211/a/aa80211standard.htm" name="http://compnetworking.about.com/cs/wireless80211/a/aa80211standard.htm" ADD_DATE="1394237028" ICON_URI="http://0.tqn.com/f/a.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://0.tqn.com/f/a.ico" style="margin-right: 0.5em;"/>Wireless Standards - 802.11a, 802.11b/g/n and 802.11ac - Which Is Best?</A><a name="Wireless Standards - 802.11a, 802.11b/g/n and 802.11ac - Which Is Best?" href="#Wireless Standards - 802.11a, 802.11b/g/n and 802.11ac - Which Is Best?" style="margin-left: 0.5em;">&para;</a>

<DD>page's own description: Which of the popular wireless home networking standards like 802.11n or 802.11ac Wi-Fi is right for you? This article explains the pros and cons of each of these wireless standards.

            </DL><p>

            <DT><a name="LDAP" href="#LDAP"><H3 ADD_DATE="1360708326">LDAP</H3></a>

            <DL><p>

                <DT><A HREF="http://www.ietf.org/rfc/rfc2253.txt" name="http://www.ietf.org/rfc/rfc2253.txt" ADD_DATE="1360708160" ICON_URI="http://www.ietf.org/favicon.ico" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="http://www.ietf.org/favicon.ico" style="margin-right: 0.5em;"/>LDAPv3 Distinguished Names</A><a name="LDAPv3 Distinguished Names" href="#LDAPv3 Distinguished Names" style="margin-left: 0.5em;">&para;</a>

"

                </DL><p>

                <DT><a name="Google Drive" href="#Google Drive"><H3 ADD_DATE="1374616221">Google Drive</H3></a>

                <DL><p>

                    <DT><A HREF="http://productforums.google.com/forum/#!topic/drive/vImyhTG7qWs%5B1-25-false%5D" name="http://productforums.google.com/forum/#!topic/drive/vImyhTG7qWs%5B1-25-false%5D" ADD_DATE="1374616110" ICON_URI="http://productforums.google.com/forum/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://productforums.google.com/forum/favicon.ico" style="margin-right: 0.5em;"/>Google Product Forums › Google Drive › Follow Symbolic Links</A><a name="Google Product Forums › Google Drive › Follow Symbolic Links" href="#Google Product Forums › Google Drive › Follow Symbolic Links" style="margin-left: 0.5em;">&para;</a>

<DD>&quot;Dropbox let&#39;s me link other folders on my computer to my Synced folder using Symbolic Links. It let&#39;s me link my Documents folder to my Dropbox and is very convenient. This doesn&#39;t seem to work with Google Drive.&quot;

                    <DT><A HREF="https://productforums.google.com/forum/#!topic/drive/_rReWfOshPw" name="https://productforums.google.com/forum/#!topic/drive/_rReWfOshPw" ADD_DATE="1391328083" ICON_URI="https://productforums.google.com/forum/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://productforums.google.com/forum/favicon.ico" style="margin-right: 0.5em;"/>Symlink workaround for mac - Google Product Forums</A><a name="Symlink workaround for mac - Google Product Forums" href="#Symlink workaround for mac - Google Product Forums" style="margin-left: 0.5em;">&para;</a>

<DD>page's own description: Free HTML XHTML CSS JavaScript jQuery XML DOM XSL XSLT RSS AJAX ASP .NET PHP SQL tutorials, references, examples for web building.

        </DL><p>

        <DT><A HREF="https://www.google.com/search?q=%s" name="https://www.google.com/search?q=%s" ADD_DATE="1318464507" ICON_URI="https://www.google.com/favicon.ico" SHORTCUTURL="g"><img width="16" height="16" src="https://www.google.com/favicon.ico" style="margin-right: 0.5em;"/>Google</A><a name="Google" href="#Google" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="javascript:(function(){var%20ca,cea,cs,df,dfe,i,j,x,y;function%20n(i,what){return%20i+%22%20%22+what+((i==1)?%22%22:%22s%22)}ca=cea=cs=0;df=document.forms;for(i=0;i<df.length;++i){x=df[i];dfe=x.elements;if(x.onsubmit){x.onsubmit=%22%22;++cs;}if(x.attributes[%22autocomplete%22]){x.attributes[%22autocomplete%22].value=%22on%22;++ca;}for(j=0;j<dfe.length;++j){y=dfe[j];if(y.attributes[%22autocomplete%22]){y.attributes[%22autocomplete%22].value=%22on%22;++cea;}}}alert(%22Removed%20autocomplete=off%20from%20%22+n(ca,%22form%22)+%22%20and%20from%20%22+n(cea,%22form%20element%22)+%22,%20and%20removed%20onsubmit%20from%20%22+n(cs,%22form%22)+%22.%20After%20you%20type%20your%20password%20and%20submit%20the%20form,%20the%20browser%20will%20offer%20to%20remember%20your%20password.%22)})();" name="javascript:(function(){var%20ca,cea,cs,df,dfe,i,j,x,y;function%20n(i,what){return%20i+%22%20%22+what+((i==1)?%22%22:%22s%22)}ca=cea=cs=0;df=document.forms;for(i=0;i<df.length;++i){x=df[i];dfe=x.elements;if(x.onsubmit){x.onsubmit=%22%22;++cs;}if(x.attributes[%22autocomplete%22]){x.attributes[%22autocomplete%22].value=%22on%22;++ca;}for(j=0;j<dfe.length;++j){y=dfe[j];if(y.attributes[%22autocomplete%22]){y.attributes[%22autocomplete%22].value=%22on%22;++cea;}}}alert(%22Removed%20autocomplete=off%20from%20%22+n(ca,%22form%22)+%22%20and%20from%20%22+n(cea,%22form%20element%22)+%22,%20and%20removed%20onsubmit%20from%20%22+n(cs,%22form%22)+%22.%20After%20you%20type%20your%20password%20and%20submit%20the%20form,%20the%20browser%20will%20offer%20to%20remember%20your%20password.%22)})();" ADD_DATE="1318292619" SHORTCUTURL="r"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>remember password</A><a name="remember password" href="#remember password" style="margin-left: 0.5em;">&para;</a>

        <HR>        <DT><A HREF="place:sort=14&type=6&maxResults=10&queryType=1" name="place:sort=14&type=6&maxResults=10&queryType=1"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Recent Tags</A><a name="Recent Tags" href="#Recent Tags" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="place:folder=BOOKMARKS_MENU&folder=UNFILED_BOOKMARKS&folder=TOOLBAR&sort=12&excludeQueries=1&maxResults=10&queryType=1" name="place:folder=BOOKMARKS_MENU&folder=UNFILED_BOOKMARKS&folder=TOOLBAR&sort=12&excludeQueries=1&maxResults=10&queryType=1"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Recently Bookmarked</A><a name="Recently Bookmarked" href="#Recently Bookmarked" style="margin-left: 0.5em;">&para;</a>