Revision 10894
Added by Aaron Marcuse-Kubitza about 11 years ago
| web/links/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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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>"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" |
| 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;">¶</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;">¶</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;">¶</a> |
|
| 681 |
<DD>"You can only add collaborators to your repository. It cannot be "co-owned"." |
|
| 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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</a> |
|
| 1066 |
<DD>"For UNDEFINED, MySQL chooses which algorithm to use" |
|
| 1067 |
|
|
| 1068 |
"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" |
|
| 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;">¶</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;">¶</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 > POSTGRESQL</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 5.1.7 Server SQL Modes > POSTGRESQL" href="#MySQL :: MySQL 5.5 Reference Manual :: 5.1.7 Server SQL Modes > POSTGRESQL" style="margin-left: 0.5em;">¶</a> |
| 1065 | 1072 |
<DD>"Equivalent to PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_FIELD_OPTIONS." |
| 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;">¶</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;">¶</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;">¶</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 & |
|
| 1081 |
sudo mysql |
|
| 1082 |
> INSERT INTO mysql.user (Host, User, Password) VALUES ('localhost', 'user', PASSWORD('password')); |
|
| 1083 |
sudo kill "$(cat /var/run/mysqld/mysqld.pid)" |
|
| 1084 |
sudo service mysql start |
|
| 1085 |
mysql |
|
| 1086 |
> GRANT SELECT, SHOW VIEW ON `db`.* TO 'user'@'localhost' 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;">¶</a> |
| 1069 | 1088 |
<DD>"Because modifying the columns of the clustered index is an expensive operation, choose primary columns that are rarely or never updated." |
| 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;">¶</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;">¶</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;">¶</a> |
|
| 1073 |
<DD>"For UNDEFINED, MySQL chooses which algorithm to use" |
|
| 1074 |
|
|
| 1075 |
"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" |
|
| 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;">¶</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;">¶</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;">¶</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 > 18.7.1. Planner Method Configuration (enable_seqscan, etc.)</A><a name="PostgreSQL: Documentation: 9.1: Query Planning > 18.7.1. Planner Method Configuration (enable_seqscan, etc.)" href="#PostgreSQL: Documentation: 9.1: Query Planning > 18.7.1. Planner Method Configuration (enable_seqscan, etc.)" style="margin-left: 0.5em;">¶</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 > 23.1.5. The Autovacuum Daemon</A><a name="PostgreSQL: Documentation: 9.1: Routine Vacuuming > 23.1.5. The Autovacuum Daemon" href="#PostgreSQL: Documentation: 9.1: Routine Vacuuming > 23.1.5. The Autovacuum Daemon" style="margin-left: 0.5em;">¶</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;">¶</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;">¶</a> |
| ... | ... | |
| 1353 | 1369 |
"Vacuuming (whether automatic or manual) stops at the oldest transaction id that is still in use." (as opposed to skipping past any active transactions to completed ones) |
| 1354 | 1370 |
|
| 1355 | 1371 |
"autovacuum will abort if it is not able to obtain a table lock within one second" |
| 1372 |
"postgres[13251]: [40-1] user=,db= ERROR: canceling autovacuum task" |
|
| 1373 |
"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." |
|
| 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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</a> |
|
| 1462 |
<DD>"In PG your procedures aren't separate transactions" |
|
| 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;">¶</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
web/links/index.htm: updated to Firefox bookmarks. MySQL: added steps to add a user if you are not root but have sudo access.