https://wiki.postgresql.org/api.php?action=feedcontributions&user=Masini&feedformat=atomPostgreSQL wiki - User contributions [en]2024-03-29T10:08:21ZUser contributionsMediaWiki 1.35.13https://wiki.postgresql.org/index.php?title=Events&diff=10243Events2010-03-15T17:41:23Z<p>Masini: /* External Links */</p>
<hr />
<div>== PostgreSQL Events ==<br />
<br />
Most PostgreSQL-specific events are tracked on the [http://www.postgresql.org/about/eventarchive PostgreSQL Events] page. This is a listing of events at which we expect, or would like to have, a PostgreSQL presence. Please keep the events in order by starting date and follow the existing examples. Please also tag the events with the MediaWiki "PostgreSQL Events" category. If you are going to be organizing a PostgreSQL booth, please adhere to [[BoothPolicies]].<br />
<br />
{| border="1"<br />
|+ <br />
'''Upcoming PostgreSQL Events Listing'''<br />
| '''Event''' || '''Web Page''' || '''Date''' || '''Country''' || '''City''' || '''Activities'''<br />
|- style="background:Khaki;"<br />
|-<br />
| [[CLT 10]] || [http://chemnitzer.linux-tage.de/2010/info/ Chemnitzer Linuxtage] || March 13-14, 2010 || Germany || Chemnitz || Booth, Talks, Workshop<br />
|}<br />
<br />
<br />
{| border="1"<br />
|+ <br />
'''Older PostgreSQL Events Listing'''<br />
| '''Event''' || '''Web Page''' || '''Date''' || '''Country''' || '''City''' || '''Activities'''<br />
|- style="background:Khaki;"<br />
|-<br />
| [[FOSDEM, Brussels 2010]] || [http://www.fosdem.org/2010/ FOSDEM '10] || February 06-07, 2010 || Belgium || Brussels || Booth, Devroom<br />
|-<br />
| [[Large Installations and System Administration Conference]] || [http://www.usenix.org/event/lisa09/ LISA 2009] || November 1-6, 2009 || USA || Baltimore, Maryland || Booth <br />
|-<br />
| [[European PGDay 2009]] || [http://www.pgday.eu/ European PGDay 2009] || Nov 6-7, 2009 || France || Paris || [http://wiki.postgresql.fr/en:pgday2009:start Tutorials, Talks, Party]<br />
|-<br />
| [[PostgreSQL Cluster Developers' Meeting]] || [http://www.postgresql.jp/events/pgcon09j/e/dev_mtg Call for participants] || November 19, 2009 || Japan || Tokyo || <br />
|-<br />
| [[PostgreSQL Conference 2009 Japan]] || [http://www.postgresql.jp/events/pgcon09j/e/ JPUG 10th Anniversary Conference] || November 20-21, 2009 || Japan || Tokyo || <br />
|-<br />
| [[OSDC 2009]] || [http://2009.osdc.com.au/ OSDC Brisbane] || November 25-27, 2009 || Australia || Brisbane || <br />
|-<br />
| [[PGCon Brazil]] || [http://pgcon.postgresql.org.br/2009/index.en.php PGCon Brazil 2009] || October 23-24, 2009 || Brazil || Unicamp, Campinas, SP ||<br />
|-<br />
| [[PgWest]] || [http://www.postgresqlconference.org/2009/west PgWest 2009 Seattle] || October 16-18, 2009 || USA || Seattle, WA || [http://www.postgresqlconference.org/2009/west/schedule Tutorials, Talks],[[Hackers' Lounge]], [[After-Thing]]<br />
|-<br />
| [[FrOSCon 2009]] || [http://www.froscon.org/ FrOSCon 2009] || August 22-23, 2009 || Germany || St. Augustin || Devroom<br />
|-<br />
| [[USENIX]] || [http://www.usenix.org/events/sec09/ USENIX Security '09] || August 10-14, 2009 || Canada || Montreal || <br />
|- style="background:Khaki;"<br />
| [[OSCON]] || [http://conferences.oreillynet.com/ OSCON 2009] || July 20-24, 2009 || USA || San Jose, CA || pgDay, Speakers, Booth<br />
|- style="background:Khaki;"<br />
| [[pgDaySanJose2009]] || [[pgDaySanJose2009]] || July 19, 2009 || USA || San Jose, CA || full day<br />
|-<br />
| [[SIGMOD]] || [http://www.sigmod09.org/ ACM SIGMOD/PODS 2009] || June 29-July 2, 2009 || USA || Providence, RI || <br />
|-<br />
| [[BOSC]] || [http://www.open-bio.org/wiki/BOSC_2009 BOSC 2009] || June 25-26, 2009 || Sweden || Stockholm || <br />
|-<br />
| [[USENIX]] || [http://www.usenix.org/events/usenix09/ USENIX '09] || June 14-19, 2009 || USA || San Diego, CA || <br />
|- style="background:Khaki;"<br />
| [[PGCon 2009]] || [http://www.pgcon.org/ PGCon 2009] || May 19-22, 2009 || Canada || Ottawa || Tutorials, Talks, Party<br />
|-<br />
| [[NWLinuxFest]] || [http://linuxfestnorthwest.org/ NWLinuxFest 2009] || April 25-26, 2009 || USA || Bellingham, WA || Booth<br />
|-<br />
| [[DASFAA]] || [http://www.wikicfp.com/cfp/servlet/event.showcfp?eventid=3177 DASFAA] || April 21-23, 2009 || Australia || Brisbane || <br />
|- style="background:Khaki;"<br />
| [[Pg Conference Spring 2009]] || [http://www.postgresqlconference.org/ PostgreSQL Conference East 2009] || April 3-5, 2009 || USA || Philadelphia || Speakers(s), Party <br /> [[PostgreSQLConferenceEast2009|Papers]]<br />
|-<br />
| [[EDBT]] || [http://www.math.spbu.ru/edbticdt/ EDBT/ICDT 2009] || March 23-26, 2009 || Russia || St. Petersburg || <br />
|-<br />
| [[CLT 09]] || [http://chemnitzer.linux-tage.de/2009/info/ Chemnitzer Linuxtage] || March 14-15, 2009 || Germany || Chemnitz || Booth, Talks, Workshop ([http://andreas.scherbaum.la/blog/archives/525-PostgreSQL-auf-den-Chemnitzer-Linuxtagen.html Infos])<br />
|-<br />
| [[OSBC]] || [http://www.infoworld.com/event/osbc/09/ Open Source Business Conference] || March 10-11, 2009 || USA || San Francisco, CA || No plans<br />
|-<br />
| [[Solutions Linux]] || [http://www.solutionslinux.fr/ Solutions Linux] || March 31 & April 1-2 , 2009|| France || Paris || [http://wiki.postgresql.fr/sl2009:start Booth, Talks]<br />
|- <br />
| [[FAST09]] || [http://www.usenix.org/events/fast09/ USENIX FAST '09] || February 24-27, 2009 || USA || San Francisco, CA || Didn't attend<br />
|-<br />
| [[Perl Workshop 2009]] || [http://www.perl-workshop.de/talks/151/view Perl Workshop '09] || February 25-27, 2009 || Germany || Frankfurt/Main || [http://andreas.scherbaum.la/blog/archives/530-Unterlagen-fuer-Tutorial-beim-Perl-Workshop-in-FrankfurtMain.html Tutorial]<br />
|-<br />
| [[SCALE]] || [http://scale7x.socallinuxexpo.org/ SCALE 7x] || February 20-22, 2009 || USA || Los Angeles, CA || Booth, BoF<br />
|-<br />
| [[FOSDEM, Brussels 2009]] || [http://www.fosdem.org/2009/ FOSDEM '09] || February 07-08, 2009 || Belgium || Brussels || Booth, Devroom<br />
|-<br />
| [[ADBC]] || [http://www.cse.unsw.edu.au/~adc09/ 20th Australasian Database Conference] || January 20-23, 2009 || New Zealand || Wellington || <br />
|-<br />
| [[LinuxConfAU]] || [http://linux.conf.au/ linux.conf.au] || January 21-23, 2009 || Australia || Tasmania || <br />
|-<br />
| colspan="6" | [[Events/2008 | 2008 events]]<br />
|-<br />
| colspan="6" | [[Events/2007 | 2007 events]]<br />
|}<br />
<br />
== External Links ==<br />
<br />
* [http://conferences.oreillynet.com/ O'Reilly conferences]<br />
* [http://opencheese.com/2007/10/14/open-source-events-2008/ "Open Source and Linux events in 2008"]<br />
* [http://www.all-auto.ro/dezmembrari-auto dezmembrari auto] Open source 2008<br />
<br />
[[Category:PostgreSQL Events]]<br />
[[Category:Advocacy]]</div>Masinihttps://wiki.postgresql.org/index.php?title=Community_Generated_Articles,_Guides,_and_Documentation&diff=10242Community Generated Articles, Guides, and Documentation2010-03-15T17:39:58Z<p>Masini: /* Deprecated articles */</p>
<hr />
<div>=Major article and documentation topic subsections=<br />
* [[Detailed installation guides]]<br />
* [[Converting from other Databases to PostgreSQL]]<br />
* [[Database Administration and Maintenance]]<br />
* [[Development Articles|Development with PostgreSQL]]<br />
* [[Performance Optimization|PostgreSQL Performance Optimization]]<br />
* [[Frequently Asked Questions]]<br />
* [[Replication, Clustering, and Connection Pooling]]<br />
<br />
=Community Generated Articles=<br />
<br />
== Introductory ==<br />
<br />
* [[Introduction to PostgreSQL Rules - Making entries which can't be altered]] by Justin Clift (2001-07-20)<br />
* [[:Image:SequencesTutorial.swf|A Shockwave tutorial on Sequences]] by Justin Clift<br />
* [[:Image:ReferentialIntegrityTutorial.swf|A Shockwave tutorial on Referential Integrity]] by Justin Clift<br />
<br />
== Other Applications ==<br />
<br />
* [[Community Guide to PostgreSQL GUI Tools]]<br />
* [http://qmail-sql.digibel.be/ Qmail using PostgreSQL user authentication] by Michael Devogelaere<br />
* HOWTO: [[PostgreSQL and Crystal Reports]] by Mike Godshall (2004-03-24)<br />
* [[:Image:Postgres-Domino6.pdf|Using PostgreSQL for a Domino 6 RDBMS Backend]] (pdf) by Keith Perry<br />
* [[Using Echelon SQL Scripter with PostgreSQL]] by Branden Williams and Matt Springfield<br />
* [[PostgreSQL derived databases]]<br />
* [http://www.postgresonline.com/journal/index.php?/archives/8-Using-OpenOffice-Base-2.3.1-with-PostgreSQL.html Using Open Office Base 2.3.1 with PostgreSQL] Postgres OnLine Journal (January/February 2008)<br />
* [http://wiki.services.openoffice.org/wiki/Base/connectivity/PostgreSQL Using OOo Base to connect to PostgreSQL] - OpenOffice.org Wiki<br />
<br />
== PostgreSQL Usage ==<br />
<br />
* [http://www.archonet.com/pgdocs/pgnotes.html PostgreSQL Notes] by Richard Huxton<br />
* [[A Brief Real-world Trigger Example]] by Richard Huxton<br />
* [http://www.alberton.info/postgresql_meta_info.html Retrieving Database meta-data from the Information Schema] by Lorenzo Alberton (2006-05-02)<br />
* [http://wiki.ael.be/index.php/PostgresQL101 PostgreSQL 101] by Shridhar Daithankar (2006-05-01)<br />
* FAQ: [[Working with Dates and Times in PostgreSQL]] by Josh Berkus (2001-08-25)<br />
* [[How to avoid overlapping intervals with PostgreSQL]] by Matteo Nastasi (2001-07-16)<br />
* [[COPY]] by Jeff Eckermann (2001-09-17), rewritten (2008-03-02) Evan Carroll<br />
* [http://www.postgresonline.com/journal/index.php?/archives/17-PostgreSQL-8.3-Cheat-Sheet-Overview.html PostgreSQL 8.3 Cheat Sheet] by Postgres OnLine (January/February 2008)<br />
* [http://www.postgresonline.com/journal/index.php?/archives/55-PostgreSQL-8.3-TSearch-Cheat-Sheet-Overview.html PostgreSQL 8.3 TSearch Full-Text Search Cheat Sheet] by Postgres OnLine (May/June 2008)<br />
<br />
== Troubleshooting ==<br />
<br />
* [[Generating a stack trace of a PostgreSQL backend]]<br />
<br />
= Deprecated articles =<br />
These are articles that are not really applicable to current versions of PostgreSQL, but are kept here for those still running those old versions:<br />
<br />
* [[Information on the 8.1.4/8.0.8/etc. Security Release]]<br />
* [http://mark.stosberg.com/Tech/postgres/pg-65-7-upgrade.html Tips for upgrading PostgreSQL from 6.5.3 to 7.0.3] by Mark Stosberg<br />
* [http://www.linux-mag.com/id/1573 Overview of new features in PostgreSQL 7.4] by Josh Berkus and Joe Conway (2004-02)<br />
* Replication HOWTO: [[Setting up RServ with PostgreSQL 7.0.3]] by S.Gopi (2001-09-13)<br />
* [http://www.all-auto.ro/auto-second-hand vanzari auto] (2004 - 04- 03) by Antony Monroe<br />
* [http://www.rot13.org/%7Edpavlin/usogres/index.html Usogres Replication Test report] by Dobrica Pavlinusic (2002-04-22)<br />
* HOWTO : [[Full Text Indexing with PostgreSQL]] using contrib/fulltextindex by Christopher Kings-Lynne (2002-04-07)<br />
* [[PostgreSQL for Enterprise Business Applications]] by Ron Chmara (2002-01-29)</div>Masinihttps://wiki.postgresql.org/index.php?title=Community_Generated_Articles,_Guides,_and_Documentation&diff=10241Community Generated Articles, Guides, and Documentation2010-03-15T17:39:32Z<p>Masini: /* Deprecated articles */</p>
<hr />
<div>=Major article and documentation topic subsections=<br />
* [[Detailed installation guides]]<br />
* [[Converting from other Databases to PostgreSQL]]<br />
* [[Database Administration and Maintenance]]<br />
* [[Development Articles|Development with PostgreSQL]]<br />
* [[Performance Optimization|PostgreSQL Performance Optimization]]<br />
* [[Frequently Asked Questions]]<br />
* [[Replication, Clustering, and Connection Pooling]]<br />
<br />
=Community Generated Articles=<br />
<br />
== Introductory ==<br />
<br />
* [[Introduction to PostgreSQL Rules - Making entries which can't be altered]] by Justin Clift (2001-07-20)<br />
* [[:Image:SequencesTutorial.swf|A Shockwave tutorial on Sequences]] by Justin Clift<br />
* [[:Image:ReferentialIntegrityTutorial.swf|A Shockwave tutorial on Referential Integrity]] by Justin Clift<br />
<br />
== Other Applications ==<br />
<br />
* [[Community Guide to PostgreSQL GUI Tools]]<br />
* [http://qmail-sql.digibel.be/ Qmail using PostgreSQL user authentication] by Michael Devogelaere<br />
* HOWTO: [[PostgreSQL and Crystal Reports]] by Mike Godshall (2004-03-24)<br />
* [[:Image:Postgres-Domino6.pdf|Using PostgreSQL for a Domino 6 RDBMS Backend]] (pdf) by Keith Perry<br />
* [[Using Echelon SQL Scripter with PostgreSQL]] by Branden Williams and Matt Springfield<br />
* [[PostgreSQL derived databases]]<br />
* [http://www.postgresonline.com/journal/index.php?/archives/8-Using-OpenOffice-Base-2.3.1-with-PostgreSQL.html Using Open Office Base 2.3.1 with PostgreSQL] Postgres OnLine Journal (January/February 2008)<br />
* [http://wiki.services.openoffice.org/wiki/Base/connectivity/PostgreSQL Using OOo Base to connect to PostgreSQL] - OpenOffice.org Wiki<br />
<br />
== PostgreSQL Usage ==<br />
<br />
* [http://www.archonet.com/pgdocs/pgnotes.html PostgreSQL Notes] by Richard Huxton<br />
* [[A Brief Real-world Trigger Example]] by Richard Huxton<br />
* [http://www.alberton.info/postgresql_meta_info.html Retrieving Database meta-data from the Information Schema] by Lorenzo Alberton (2006-05-02)<br />
* [http://wiki.ael.be/index.php/PostgresQL101 PostgreSQL 101] by Shridhar Daithankar (2006-05-01)<br />
* FAQ: [[Working with Dates and Times in PostgreSQL]] by Josh Berkus (2001-08-25)<br />
* [[How to avoid overlapping intervals with PostgreSQL]] by Matteo Nastasi (2001-07-16)<br />
* [[COPY]] by Jeff Eckermann (2001-09-17), rewritten (2008-03-02) Evan Carroll<br />
* [http://www.postgresonline.com/journal/index.php?/archives/17-PostgreSQL-8.3-Cheat-Sheet-Overview.html PostgreSQL 8.3 Cheat Sheet] by Postgres OnLine (January/February 2008)<br />
* [http://www.postgresonline.com/journal/index.php?/archives/55-PostgreSQL-8.3-TSearch-Cheat-Sheet-Overview.html PostgreSQL 8.3 TSearch Full-Text Search Cheat Sheet] by Postgres OnLine (May/June 2008)<br />
<br />
== Troubleshooting ==<br />
<br />
* [[Generating a stack trace of a PostgreSQL backend]]<br />
<br />
= Deprecated articles =<br />
These are articles that are not really applicable to current versions of PostgreSQL, but are kept here for those still running those old versions:<br />
<br />
* [[Information on the 8.1.4/8.0.8/etc. Security Release]]<br />
* [http://mark.stosberg.com/Tech/postgres/pg-65-7-upgrade.html Tips for upgrading PostgreSQL from 6.5.3 to 7.0.3] by Mark Stosberg<br />
* [http://www.linux-mag.com/id/1573 Overview of new features in PostgreSQL 7.4] by Josh Berkus and Joe Conway (2004-02)<br />
* Replication HOWTO: [[Setting up RServ with PostgreSQL 7.0.3]] by S.Gopi (2001-09-13)<br />
* [http://www.all-auto.ro/auto-second-hand] (2004 - 04- 03) by Antony Monroe<br />
* [http://www.rot13.org/%7Edpavlin/usogres/index.html Usogres Replication Test report] by Dobrica Pavlinusic (2002-04-22)<br />
* HOWTO : [[Full Text Indexing with PostgreSQL]] using contrib/fulltextindex by Christopher Kings-Lynne (2002-04-07)<br />
* [[PostgreSQL for Enterprise Business Applications]] by Ron Chmara (2002-01-29)</div>Masinihttps://wiki.postgresql.org/index.php?title=Performance_Optimization&diff=10240Performance Optimization2010-03-15T17:37:36Z<p>Masini: /* Benchmark Workloads */</p>
<hr />
<div>== General Setup and Optimization ==<br />
* [[Tuning Your PostgreSQL Server]] by Greg Smith, Robert Treat, and Christopher Browne<br />
* [http://www.pgcon.org/2008/schedule/events/104.en.html GUCs: A Three Hour Tour] by Josh Berkus. Also useful here is his [http://pgfoundry.org/docman/view.php/1000106/84/calcfactors.sxc tuning OpenOffice spreadsheet], which suggests tuning values for 5 different types of workloads. <br />
* [http://linuxfinances.info/info/quickstart.html QuickStart Guide to Tuning PostgreSQL] by Christopher Browne<br />
* [http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm 5-Minute Introduction to PostgreSQL Performance] by Greg Smith<br />
* [http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html Annotated postgresql.conf] by Josh Berkus and Shridhar Daithankar (older V7.4 targeted version of material covered in the GUC tour referenced above)<br />
* [http://www.varlena.com/GeneralBits/Tidbits/perf.html Performance Tuning] by Josh Berkus and Shridhar Daithankar<br />
* [http://www.zope.org/Members/pupq/pg_in_aggregates Replacing Slow Loops in PostgreSQL] by Joel Burton<br />
* [http://www.postgresql.org/files/documentation/books/aw_pgsql/hw_performance/ PostgreSQL Hardware Performance Tuning] by Bruce Momjian<br />
* [http://www.targeted.org/articles/databases/fragmentation.html The effects of data fragmentation in a mixed load database] by Dmitry Dvoinikov<br />
* [http://www.2ndQuadrant.com/download/Postgres_Performance_Update83.pdf PostgreSQL Performance Features in 8.3] by Simon Riggs<br />
* [http://www.2ndQuadrant.com/download/Postgres_Performance_Update84.pdf PostgreSQL Performance Features in 8.4] by Simon Riggs<br />
<br />
Performance courses are available from a number of companies. Check [http://www.postgresql.org/about/eventarchive events and trainings] for further details.<br />
<br />
==Critical maintenance for performance==<br />
*[[Introduction to VACUUM, ANALYZE, EXPLAIN, and COUNT]] by Jim Nasby.<br />
*[[VACUUM FULL]] and why you should avoid it<br />
*[[Planner Statistics]]<br />
*[[Using EXPLAIN]]<br />
*[[Logging Difficult Queries]]<br />
*[[Logging Checkpoints]]<br />
*[http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm Checkpoints and the Background Writer: PostgreSQL 8.3 Improvements and Migration] by Greg Smith<br />
*[[Bulk Loading and Restores]]<br />
*[[Performance Analysis Tools]] by Craig Ringer<br />
<br />
== Database architecture ==<br />
* [[Priorities|Limiting and prioritizing user/query/database resource usage]] by Craig Ringer<br />
* [[Prioritizing databases by separating into multiple clusters]] by Craig Ringer<br />
* [[Clustering]]<br />
<br />
==Database Hardware Selection and Setup==<br />
* [[Database Hardware]]<br />
<br />
==Benchmark Workloads== <br />
* [[:Category:Benchmarking]]<br />
<br />
[[Category:Administration]][[Category:Performance]]<br />
External links:<br />
*[http://www.all-auto.ro/piese-auto piese auto online]<br />
*[http://www.all-auto.ro masini]</div>Masini