Project

General

Profile

« Previous | Next » 

Revision 10894

Added by Aaron Marcuse-Kubitza over 11 years ago

web/links/index.htm: updated to Firefox bookmarks. MySQL: added steps to add a user if you are not root but have sudo access.

View differences:

index.htm
239 239 
        </DL><p>
240 240 
        <DT><a name="iPlant" href="#iPlant"><H3 ADD_DATE="1333400096">iPlant</H3></a>
241 241 
        <DL><p>
242 
            <DT><A HREF="https://atmo.iplantcollaborative.org/application/" name="https://atmo.iplantcollaborative.org/application/" ADD_DATE="1351209187" ICON_URI="https://auth.iplantcollaborative.org/cas/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://auth.iplantcollaborative.org/cas/favicon.ico" style="margin-right: 0.5em;"/>Atmosphere</A><a name="Atmosphere" href="#Atmosphere" style="margin-left: 0.5em;">&para;</a>
242 
            <DT><A HREF="https://atmo.iplantcollaborative.org/application/" name="https://atmo.iplantcollaborative.org/application/" ADD_DATE="1351209187" ICON_URI="https://atmo.iplantcollaborative.org/resources/images/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://atmo.iplantcollaborative.org/resources/images/favicon.ico" style="margin-right: 0.5em;"/>Atmosphere</A><a name="Atmosphere" href="#Atmosphere" style="margin-left: 0.5em;">&para;</a>
243 243 
            <DT><A HREF="https://iplant.webex.com/cmp0307l/webcomponents/widget/globalcallin/globalcallin.do?siteurl=iplant&serviceType=MC&eventID=196234947&tollFree=1" name="https://iplant.webex.com/cmp0307l/webcomponents/widget/globalcallin/globalcallin.do?siteurl=iplant&serviceType=MC&eventID=196234947&tollFree=1" ADD_DATE="1333400068" ICON_URI="https://iplant.webex.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://iplant.webex.com/favicon.ico" style="margin-right: 0.5em;"/>Global call-in numbers</A><a name="Global call-in numbers" href="#Global call-in numbers" style="margin-left: 0.5em;">&para;</a>
244 244 
<DD>page's description: 85
245 245 
            <DT><A HREF="http://www.iplantcollaborative.org/sites/default/files/iPlantCLA.txt" name="http://www.iplantcollaborative.org/sites/default/files/iPlantCLA.txt" ADD_DATE="1371150306" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>iPlant Collaborative Contributor License Agreement</A><a name="iPlant Collaborative Contributor License Agreement" href="#iPlant Collaborative Contributor License Agreement" style="margin-left: 0.5em;">&para;</a>
......
252 252 
            <DT><A HREF="http://tnrs.iplantcollaborative.org/instructions.html#download_results" name="http://tnrs.iplantcollaborative.org/instructions.html#download_results" ADD_DATE="1371599361" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Taxonomic Name Resolution Service - Instructions</A><a name="Taxonomic Name Resolution Service - Instructions" href="#Taxonomic Name Resolution Service - Instructions" style="margin-left: 0.5em;">&para;</a>
253 253 
            <DT><A HREF="http://asmarterplanet.com/blog/2012/02/big-data-the-view-from-the-classroom.html" name="http://asmarterplanet.com/blog/2012/02/big-data-the-view-from-the-classroom.html" ADD_DATE="1375339514" ICON_URI="http://asmarterplanet.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://asmarterplanet.com/favicon.ico" style="margin-right: 0.5em;"/>Big Data: The View From The Classroom « A Smarter Planet Blog A Smarter Planet Blog</A><a name="Big Data: The View From The Classroom « A Smarter Planet Blog A Smarter Planet Blog" href="#Big Data: The View From The Classroom « A Smarter Planet Blog A Smarter Planet Blog" style="margin-left: 0.5em;">&para;</a>
254 254 
<DD>page's description: by Nirav Merchant, iPlant Collaborative, Director, BioComputing at the Arizona Research Laboratories (ARL), The University of Arizona Today researchers in
255 
            <DT><A HREF="https://pods.iplantcollaborative.org/wiki/display/start/Data+Store+Quick+Start#DataStoreQuickStart-ConnectingwithWebDAV%28Mac%29" name="https://pods.iplantcollaborative.org/wiki/display/start/Data+Store+Quick+Start#DataStoreQuickStart-ConnectingwithWebDAV%28Mac%29" ADD_DATE="1378420169" 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;"/>Data Store Quick Start - 1 Getting Started with iPlant - iPlant Collaborative Wiki</A><a name="Data Store Quick Start - 1 Getting Started with iPlant - iPlant Collaborative Wiki" href="#Data Store Quick Start - 1 Getting Started with iPlant - iPlant Collaborative Wiki" style="margin-left: 0.5em;">&para;</a>
255 256 
        </DL><p>
256 257 
        <DT><a name="resources" href="#resources"><H3 ADD_DATE="1317674664">resources</H3></a>
257 258 
        <DL><p>
......
676 677 
<DD>&quot;I use git rebase -i to make sure every commit is clean. For example, when I have two commits with broken code followed by a third clean commit&quot;
677 678 
                    <DT><A HREF="http://viget.com/extend/effectively-using-git-with-subversion" name="http://viget.com/extend/effectively-using-git-with-subversion" ADD_DATE="1365937443" ICON_URI="http://viget.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://viget.com/favicon.ico" style="margin-right: 0.5em;"/>Effectively Using Git With Subversion | Viget</A><a name="Effectively Using Git With Subversion | Viget" href="#Effectively Using Git With Subversion | Viget" style="margin-left: 0.5em;">&para;</a>
678 679 
                    <DT><A HREF="http://emmanuelbernard.com/blog/2009/01/16/how-to-install-git-and-git-svn-on-mac-os-x/" name="http://emmanuelbernard.com/blog/2009/01/16/how-to-install-git-and-git-svn-on-mac-os-x/" ADD_DATE="1365938585" ICON_URI="http://emmanuelbernard.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://emmanuelbernard.com/favicon.ico" style="margin-right: 0.5em;"/>Emmanuel Bernard: How to install Git and git-svn on Mac OS X</A><a name="Emmanuel Bernard: How to install Git and git-svn on Mac OS X" href="#Emmanuel Bernard: How to install Git and git-svn on Mac OS X" style="margin-left: 0.5em;">&para;</a>
680 
                    <DT><A HREF="http://stackoverflow.com/questions/8015579/add-another-user-to-project-owners-in-github" name="http://stackoverflow.com/questions/8015579/add-another-user-to-project-owners-in-github" ADD_DATE="1378418168" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>git - Add another user to project owners in Github - Stack Overflow</A><a name="git - Add another user to project owners in Github - Stack Overflow" href="#git - Add another user to project owners in Github - Stack Overflow" style="margin-left: 0.5em;">&para;</a>
681 
<DD>&quot;You can only add collaborators to your repository. It cannot be &quot;co-owned&quot;.&quot;
679 682 
                </DL><p>
680 683 
                <DT><A HREF="http://en.wikipedia.org/wiki/Concurrent_Versions_System" name="http://en.wikipedia.org/wiki/Concurrent_Versions_System" ADD_DATE="1366706532" ICON_URI="http://bits.wikimedia.org/favicon/wikipedia.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bits.wikimedia.org/favicon/wikipedia.ico" style="margin-right: 0.5em;"/>Concurrent Versions System - Wikipedia, the free encyclopedia</A><a name="Concurrent Versions System - Wikipedia, the free encyclopedia" href="#Concurrent Versions System - Wikipedia, the free encyclopedia" style="margin-left: 0.5em;">&para;</a>
681 684 
                <DT><A HREF="http://en.wikipedia.org/wiki/Revision_Control_System" name="http://en.wikipedia.org/wiki/Revision_Control_System" ADD_DATE="1366705870" ICON_URI="http://bits.wikimedia.org/favicon/wikipedia.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bits.wikimedia.org/favicon/wikipedia.ico" style="margin-right: 0.5em;"/>Revision Control System - Wikipedia, the free encyclopedia</A><a name="Revision Control System - Wikipedia, the free encyclopedia" href="#Revision Control System - Wikipedia, the free encyclopedia" style="margin-left: 0.5em;">&para;</a>
......
1059 1062 
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/kill.html" name="http://dev.mysql.com/doc/refman/5.5/en/kill.html" ADD_DATE="1369431847" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 13.7.6.4 KILL Syntax</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 13.7.6.4 KILL Syntax" href="#MySQL :: MySQL 5.5 Reference Manual :: 13.7.6.4 KILL Syntax" style="margin-left: 0.5em;">&para;</a>
1060 1063 
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html" name="http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html" ADD_DATE="1366744812" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 14.3.15 Limits on InnoDB Tables</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 14.3.15 Limits on InnoDB Tables" href="#MySQL :: MySQL 5.5 Reference Manual :: 14.3.15 Limits on InnoDB Tables" style="margin-left: 0.5em;">&para;</a>
1061 1064 
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/innodb-create-index-overview.html" name="http://dev.mysql.com/doc/refman/5.5/en/innodb-create-index-overview.html" ADD_DATE="1366895888" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 14.4.2.1 Overview of Fast Index Creation</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 14.4.2.1 Overview of Fast Index Creation" href="#MySQL :: MySQL 5.5 Reference Manual :: 14.4.2.1 Overview of Fast Index Creation" style="margin-left: 0.5em;">&para;</a>
1065 
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/view-algorithms.html" name="http://dev.mysql.com/doc/refman/5.5/en/view-algorithms.html" ADD_DATE="1369922467" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 19.5.2 View Processing Algorithms</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 19.5.2 View Processing Algorithms" href="#MySQL :: MySQL 5.5 Reference Manual :: 19.5.2 View Processing Algorithms" style="margin-left: 0.5em;">&para;</a>
1066 
<DD>&quot;For UNDEFINED, MySQL chooses which algorithm to use&quot;
1067 

  		




  
  1068
  
    
&quot;A reason to choose TEMPTABLE explicitly is that locks can be released on underlying tables after the temporary table has been created and before it is used to finish processing the statement&quot;


  		




  1062
  1069
  
    
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html" name="http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html" ADD_DATE="1366893751" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.1 mysql Options</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.1 mysql Options" href="#MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.1 mysql Options" style="margin-left: 0.5em;">&para;</a>


  		




  1063
  1070
  
    
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/mysql-commands.html" name="http://dev.mysql.com/doc/refman/5.5/en/mysql-commands.html" ADD_DATE="1364873441" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.2 mysql Commands</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.2 mysql Commands" href="#MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.2 mysql Commands" style="margin-left: 0.5em;">&para;</a>


  		




  1064
  1071
  
    
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html#sqlmode_postgresql" name="http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html#sqlmode_postgresql" ADD_DATE="1368048993" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 5.1.7 Server SQL Modes &gt; POSTGRESQL</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 5.1.7 Server SQL Modes &gt; POSTGRESQL" href="#MySQL :: MySQL 5.5 Reference Manual :: 5.1.7 Server SQL Modes &gt; POSTGRESQL" style="margin-left: 0.5em;">&para;</a>


  		




  1065
  1072
  
    
<DD>&quot;Equivalent to PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_FIELD_OPTIONS.&quot;


  		




  1066
  1073
  
    
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/index-btree-hash.html" name="http://dev.mysql.com/doc/refman/5.5/en/index-btree-hash.html" ADD_DATE="1366865295" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 8.3.8 Comparison of B-Tree and Hash Indexes</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 8.3.8 Comparison of B-Tree and Hash Indexes" href="#MySQL :: MySQL 5.5 Reference Manual :: 8.3.8 Comparison of B-Tree and Hash Indexes" style="margin-left: 0.5em;">&para;</a>


  		




  1067
  1074
  
    
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/identifiers.html" name="http://dev.mysql.com/doc/refman/5.5/en/identifiers.html" ADD_DATE="1366748434" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 9.2 Schema Object Names</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 9.2 Schema Object Names" href="#MySQL :: MySQL 5.5 Reference Manual :: 9.2 Schema Object Names" style="margin-left: 0.5em;">&para;</a>


  		




  
  1075
  
    
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html" name="http://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html" ADD_DATE="1378707531" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: C.5.4.1 How to Reset the Root Password</A><a name="MySQL :: MySQL 5.5 Reference Manual :: C.5.4.1 How to Reset the Root Password" href="#MySQL :: MySQL 5.5 Reference Manual :: C.5.4.1 How to Reset the Root Password" style="margin-left: 0.5em;">&para;</a>


  		




  
  1076
  
    
<DD>-


  		




  
  1077
  
    
to add a user if you are not root but have sudo access:


  		




  
  1078
  
    

  		




  
  1079
  
    
sudo service mysql stop


  		




  
  1080
  
    
sudo mysqld --skip-grant-tables  --skip-networking &amp;


  		




  
  1081
  
    
sudo mysql


  		




  
  1082
  
    
&gt; INSERT INTO mysql.user (Host, User, Password) VALUES (&#39;localhost&#39;, &#39;user&#39;, PASSWORD(&#39;password&#39;));


  		




  
  1083
  
    
sudo kill &quot;$(cat /var/run/mysqld/mysqld.pid)&quot;


  		




  
  1084
  
    
sudo service mysql start


  		




  
  1085
  
    
mysql


  		




  
  1086
  
    
&gt; GRANT SELECT, SHOW VIEW ON `db`.* TO &#39;user&#39;@&#39;localhost&#39; WITH GRANT OPTION;


  		




  1068
  1087
  
    
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_clustered_index" name="http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_clustered_index" ADD_DATE="1366896044" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: MySQL Glossary :: clustered index</A><a name="MySQL :: MySQL 5.5 Reference Manual :: MySQL Glossary :: clustered index" href="#MySQL :: MySQL 5.5 Reference Manual :: MySQL Glossary :: clustered index" style="margin-left: 0.5em;">&para;</a>


  		




  1069
  1088
  
    
<DD>&quot;Because modifying the columns of the clustered index is an expensive operation, choose primary columns that are rarely or never updated.&quot;


  		




  1070
  1089
  
    
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.6/en/alter-database.html" name="http://dev.mysql.com/doc/refman/5.6/en/alter-database.html" ADD_DATE="1346340363" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.6 Reference Manual :: 13.1.1 ALTER DATABASE Syntax</A><a name="MySQL :: MySQL 5.6 Reference Manual :: 13.1.1 ALTER DATABASE Syntax" href="#MySQL :: MySQL 5.6 Reference Manual :: 13.1.1 ALTER DATABASE Syntax" style="margin-left: 0.5em;">&para;</a>


  		




  1071
  1090
  
    
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html" name="http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html" ADD_DATE="1346821922" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.6 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program</A><a name="MySQL :: MySQL 5.6 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program" href="#MySQL :: MySQL 5.6 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program" style="margin-left: 0.5em;">&para;</a>


  		




  1072
  
  
    
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/view-algorithms.html" name="http://dev.mysql.com/doc/refman/5.5/en/view-algorithms.html" ADD_DATE="1369922467" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 19.5.2 View Processing Algorithms</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 19.5.2 View Processing Algorithms" href="#MySQL :: MySQL 5.5 Reference Manual :: 19.5.2 View Processing Algorithms" style="margin-left: 0.5em;">&para;</a>


  		




  1073
  
  
    
<DD>&quot;For UNDEFINED, MySQL chooses which algorithm to use&quot;


  		




  1074
  
  
    

  		




  1075
  
  
    
&quot;A reason to choose TEMPTABLE explicitly is that locks can be released on underlying tables after the temporary table has been created and before it is used to finish processing the statement&quot;


  		




  1076
  1091
  
    
                        </DL><p>


  		




  1077
  1092
  
    
                        <DT><a name="dynamic SQL" href="#dynamic SQL"><H3 ADD_DATE="1366898821">dynamic SQL</H3></a>


  		




  1078
  1093
  
    
                        <DL><p>


  		




  ......




  1282
  1297
  
    
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/external-pl.html" name="http://www.postgresql.org/docs/9.1/static/external-pl.html" ADD_DATE="1362834165" 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.1: Procedural Languages</A><a name="PostgreSQL: Documentation: 9.1: Procedural Languages" href="#PostgreSQL: Documentation: 9.1: Procedural Languages" style="margin-left: 0.5em;">&para;</a>


  		




  1283
  1298
  
    
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/app-psql.html#APP-PSQL-PATTERNS" name="http://www.postgresql.org/docs/9.1/static/app-psql.html#APP-PSQL-PATTERNS" ADD_DATE="1342486329" 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.1: psql</A><a name="PostgreSQL: Documentation: 9.1: psql" href="#PostgreSQL: Documentation: 9.1: psql" style="margin-left: 0.5em;">&para;</a>


  		




  1284
  1299
  
    
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/xfunc-sql.html" name="http://www.postgresql.org/docs/9.1/static/xfunc-sql.html" ADD_DATE="1351738107" 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.1: Query Language (SQL) Functions</A><a name="PostgreSQL: Documentation: 9.1: Query Language (SQL) Functions" href="#PostgreSQL: Documentation: 9.1: Query Language (SQL) Functions" style="margin-left: 0.5em;">&para;</a>


  		




  
  1300
  
    
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE" name="http://www.postgresql.org/docs/9.1/static/runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE" ADD_DATE="1377913034" 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.1: Query Planning &gt; 18.7.1. Planner Method Configuration (enable_seqscan, etc.)</A><a name="PostgreSQL: Documentation: 9.1: Query Planning &gt; 18.7.1. Planner Method Configuration (enable_seqscan, etc.)" href="#PostgreSQL: Documentation: 9.1: Query Planning &gt; 18.7.1. Planner Method Configuration (enable_seqscan, etc.)" style="margin-left: 0.5em;">&para;</a>


  		




  1285
  1301
  
    
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html#AUTOVACUUM" name="http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html#AUTOVACUUM" ADD_DATE="1377905019" 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.1: Routine Vacuuming &gt; 23.1.5. The Autovacuum Daemon</A><a name="PostgreSQL: Documentation: 9.1: Routine Vacuuming &gt; 23.1.5. The Autovacuum Daemon" href="#PostgreSQL: Documentation: 9.1: Routine Vacuuming &gt; 23.1.5. The Autovacuum Daemon" style="margin-left: 0.5em;">&para;</a>


  		




  1286
  1302
  
    
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/lo-funcs.html" name="http://www.postgresql.org/docs/9.1/static/lo-funcs.html" ADD_DATE="1367554117" 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.1: Server-side Functions</A><a name="PostgreSQL: Documentation: 9.1: Server-side Functions" href="#PostgreSQL: Documentation: 9.1: Server-side Functions" style="margin-left: 0.5em;">&para;</a>


  		




  1287
  1303
  
    
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-set-constraints.html" name="http://www.postgresql.org/docs/9.1/static/sql-set-constraints.html" ADD_DATE="1373131555" 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.1: SET CONSTRAINTS</A><a name="PostgreSQL: Documentation: 9.1: SET CONSTRAINTS" href="#PostgreSQL: Documentation: 9.1: SET CONSTRAINTS" style="margin-left: 0.5em;">&para;</a>


  		




  ......




  1353
  1369
  
    
&quot;Vacuuming (whether automatic or manual) stops at the oldest transaction id that is still in use.&quot; (as opposed to skipping past any active transactions to completed ones)


  		




  1354
  1370
  
    

  		




  1355
  1371
  
    
&quot;autovacuum will abort if it is not able to obtain a table lock within one second&quot;


  		




  
  1372
  
    
&quot;postgres[13251]: [40-1] user=,db= ERROR:  canceling autovacuum task&quot;


  		




  
  1373
  
    
&quot;I have installed a nightly cron job to force-vacuum the database. PostgreSQL has shown much improved query responses since then. Some queries’ completion times even improved by a factor of 10.&quot;


  		




  1356
  1374
  
    
                            <DT><A HREF="http://postgresql.1045698.n5.nabble.com/Lock-problem-with-autovacuum-truncating-heap-td4265539.html" name="http://postgresql.1045698.n5.nabble.com/Lock-problem-with-autovacuum-truncating-heap-td4265539.html" ADD_DATE="1377912054" ICON_URI="http://postgresql.1045698.n5.nabble.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://postgresql.1045698.n5.nabble.com/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL - hackers - Lock problem with autovacuum truncating heap</A><a name="PostgreSQL - hackers - Lock problem with autovacuum truncating heap" href="#PostgreSQL - hackers - Lock problem with autovacuum truncating heap" style="margin-left: 0.5em;">&para;</a>


  		




  1357
  1375
  
    
<DD>page's description: Lock problem with autovacuum truncating heap. We have run across a problem with autovacuum that occurs when it can truncate off a large amount of empty blocks. It behaves different in version 9.0...


  		




  1358
  1376
  
    

  		




  ......




  1440
  1458
  
    
                        <DT><A HREF="http://stackoverflow.com/questions/2647158/how-can-i-hash-passwords-in-postgresql" name="http://stackoverflow.com/questions/2647158/how-can-i-hash-passwords-in-postgresql" ADD_DATE="1344468295" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>security - How can I hash passwords in postgresql? - Stack Overflow</A><a name="security - How can I hash passwords in postgresql? - Stack Overflow" href="#security - How can I hash passwords in postgresql? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>


  		




  1441
  1459
  
    
                        <DT><A HREF="http://www.depesz.com/2010/06/28/should-you-use-hash-index/" name="http://www.depesz.com/2010/06/28/should-you-use-hash-index/" ADD_DATE="1341863773" ICON_URI="http://www.depesz.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.depesz.com/favicon.ico" style="margin-right: 0.5em;"/>select * from depesz; » Blog Archive » Should you use HASH index?</A><a name="select * from depesz; » Blog Archive » Should you use HASH index?" href="#select * from depesz; » Blog Archive » Should you use HASH index?" style="margin-left: 0.5em;">&para;</a>


  		




  1442
  1460
  
    
                        <DT><A HREF="http://www.depesz.com/2008/08/05/waiting-for-84-hash-based-distinct/" name="http://www.depesz.com/2008/08/05/waiting-for-84-hash-based-distinct/" ADD_DATE="1351759513" ICON_URI="http://www.depesz.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.depesz.com/favicon.ico" style="margin-right: 0.5em;"/>select * from depesz; » Blog Archive » Waiting for 8.4 – hash based DISTINCT</A><a name="select * from depesz; » Blog Archive » Waiting for 8.4 – hash based DISTINCT" href="#select * from depesz; » Blog Archive » Waiting for 8.4 – hash based DISTINCT" style="margin-left: 0.5em;">&para;</a>


  		




  
  1461
  
    
                        <DT><A HREF="http://stackoverflow.com/questions/6274457/set-isolation-level-for-postgresql-stored-procedures" name="http://stackoverflow.com/questions/6274457/set-isolation-level-for-postgresql-stored-procedures" ADD_DATE="1378328473" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>set isolation level for postgresql stored procedures - Stack Overflow</A><a name="set isolation level for postgresql stored procedures - Stack Overflow" href="#set isolation level for postgresql stored procedures - Stack Overflow" style="margin-left: 0.5em;">&para;</a>


  		




  
  1462
  
    
<DD>&quot;In PG your procedures aren&#39;t separate transactions&quot;


  		




  1443
  1463
  
    
                        <DT><A HREF="http://forums.devshed.com/postgresql-help-21/slow-queries-after-convertinf-db-from-sql-ascii-to-utf8t-887470.html" name="http://forums.devshed.com/postgresql-help-21/slow-queries-after-convertinf-db-from-sql-ascii-to-utf8t-887470.html" ADD_DATE="1367833539" ICON_URI="http://forums.devshed.com/images/favicon2.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://forums.devshed.com/images/favicon2.ico" style="margin-right: 0.5em;"/>Slow queries after convertinf DB from SQL_ASCII to UTF8 - Dev Shed</A><a name="Slow queries after convertinf DB from SQL_ASCII to UTF8 - Dev Shed" href="#Slow queries after convertinf DB from SQL_ASCII to UTF8 - Dev Shed" style="margin-left: 0.5em;">&para;</a>


  		




  1444
  1464
  
    
<DD>page's description: Slow queries after convertinf DB from SQL_ASCII to UTF8- PostgreSQL Help. Visit Dev Shed to discuss Slow queries after convertinf DB from SQL_ASCII to UTF8


  		




  1445
  1465
  
    

  		












Also available in:  Unified diff