PostgreSQL wiki - User contributions [en]

User:Singh.gurjeet

Singh.gurjeet — Wed, 02 Jan 2013 17:50:05 GMT

Singh.gurjeet: Created page with "[http://gurjeet.singh.im See here]"

[http://gurjeet.singh.im See here]

IRC2RWNames

Singh.gurjeet — Wed, 02 Jan 2013 17:48:21 GMT

Singh.gurjeet: Corrected the user-page link on self entry

=== List of IRC nicks with their respective real world names ===

You can find many PostgreSQL users and developers chatting in [irc://irc.freenode.net/postgresql #postgresql on freenode]. Here's more information about some of the regulars there:

{| border="1"
|-
!Nickname || Real Name
|-
|ads || Andreas Scherbaum
|-
|agliodbs, aglio2 (freenode), jberkus (oftc) || Josh Berkus
|-
|ahammond || Andrew Hammond
|-
|alvherre || Alvaro Herrera
|-
|andres || Andres Freund
|-
|Assid || Satish Alwani
|-
|aurynn || Aurynn Shaw
|-
|BlueAidan/BlueAidan_work || [[user:davidblewett | David Blewett]]
|-
|bmomjian || Bruce Momjian
|-
|cbbrowne || Christopher Browne
|-
|cce || Clark C. Evans
|-
|chicagoben || Benjamin Johnson
|-
|crab || Abhijit Menon-Sen
|-
|Crad || Gavin M. Roy
|-
|daamien || Damien Clochard
|-
|DarcyB || Darcy Buskermolen
|-
|darkixion || Thom Brown
|-
|davidfetter || David Fetter
|-
|dbb || Brian Hamlin / darkblue_b
|-
|dcolish || [http://www.unencrypted.org Dan Colish]
|-
|dcramer || Dave Cramer
|-
|DeciBull, TheCougar || Jim C. Nasby
|-
|dennisb || Dennis Björklund
|-
|depesz || Hubert Lubaczewski
|-
|devrimgunduz || Devrim Gündüz
|-
|digicon || [http://digicondev.blogspot.com Zach Conrad]
|-
|dim || Dimitri Fontaine
|-
|direvus || Brendan Jurd
|-
|drbair || Ryan Bair
|-
|DrLou || Lou Picciano
|-
|duck_tape || Adi Alurkar
|-
|dvl || [http://langille.org/ Dan Langille]
|-
|eggyknap || Joshua Tolley
|-
|endpoint_david || David Christensen
|-
|eulerto || Euler Taveira
|-
|f3ew/devdas || Devdas Vasu Bhagat
|-
|feivel || Michael Meskes
|-
|elein || Elein Mustain
|-
|gleu || Guillaume Lelarge
|-
|gorthx || [[User:Gabrielle|Gabrielle Roth]]
|-
|grzm || Michael Glaesemann
|-
|gsmet || Guillaume Smet
|-
|gregs1104 || Greg Smith
|-
|gurjeet || [[User:singh.gurjeet|Gurjeet Singh]]
|-
|G_SabinoMullane || Greg Sabino Mullane
|-
|HarrisonF || Harrison Fisk
|-
|ioguix || Jehan-Guillaume de Rorthais
|-
|indigo || Phil Frost
|-
|intgr || Marti Raudsepp
|-
|JanniCash || Jan Wieck
|-
|jconway || Joe Conway
|-
|jdavis, jdavis_ || Jeff Davis
|-
|jkatz05 || Jonathan S. Katz
|-
|johto || Marko Tiikkaja
|-
|jurka || Kris Jurka
|-
|justatheory || David Wheeler
|-
|jpa || Jean-Paul Argudo
|-
|jwp || James Pye
|-
|j_williams || Josh Williams
|-
|kgrittn || Kevin Grittner
|-
|klando || Cédric Villemain
|-
|larryrtx || Larry Rosenman
|-
|linuxpoet, postgresman || Joshua D. Drake
|-
|lluad || Steve Atkins
|-
|lsmith || Lukas Smith
|-
|magnush || Magnus Hagander
|-
|marco44 || Marc Cousin
|-
|markwkm || Mark Wong
|-
|mastermind || [[user:mastermind | Stefan Kaltenbrunner]]
|-
|mbalmer || [[user:mbalmer | Marc Balmer]]
|-
|merlin83 || Chua Khee Chin
|-
|merlinm || Merlin Moncure
|-
|metatrontech || Chris Travers
|-
|miracee || Susanne Ebrecht
|-
|Moosbert || Peter Eisentraut
|-
|neilc || Neil Conway
|-
|oicu || Andrew Dunstan
|-
|okbobcz || Pavel Stehule
|-
|pg_docbot || [[IRCBotSyntax]]
|-
|pgSnake || Dave Page
|-
|PJMODOS || Petr Jelínek
|-
|Possible || Robert Ivens
|-
|postwait || Theo Schlossnagle
|-
|prothid || R Brenton Strickler
|-
|psoo || Bernd Helmle
|-
|pyarra || Philip Yarra
|-
|raptelan || [[user:Cshobe|Casey Allen Shobe]]
|-
|rhaas || Robert Haas
|-
|RhodiumToad (formerly AndrewSN) || Andrew Gierth
|-
|Robe || [[user:Robe | Michael Renner]]
|-
|rotellaro || Federico Campoli
|-
|rz || Kirill Simonov
|-
|SAS || Stéphane Schildknecht
|-
|schmiddy || Josh Kupershmidt
|-
|scrappy || Marc G. Fournier
|-
|selenamarie || Selena Deckelmann
|-
|SkippyDigits || Sherri Kalm
|-
|Snow-Man || Stephen Frost
|-
|Spritz || Matteo Beccati
|-
|sternocera || Peter Geoghegan
|-
|StuckMojo, MojoWork || Jon Erdman
|-
|swm || Gavin Sherry
|-
|vy || Volkan YAZICI
|-
|wulczer || Jan Urbański
|-
|xaprb || Baron Schwartz
|-
|xzilla, xzi11a || [[User:Xzilla|Robert Treat]]
|}

[[Category:Community]]

IRC2RWNames

Singh.gurjeet — Wed, 02 Jan 2013 17:47:10 GMT

Singh.gurjeet: Added self to the list

=== List of IRC nicks with their respective real world names ===

You can find many PostgreSQL users and developers chatting in [irc://irc.freenode.net/postgresql #postgresql on freenode]. Here's more information about some of the regulars there:

{| border="1"
|-
!Nickname || Real Name
|-
|ads || Andreas Scherbaum
|-
|agliodbs, aglio2 (freenode), jberkus (oftc) || Josh Berkus
|-
|ahammond || Andrew Hammond
|-
|alvherre || Alvaro Herrera
|-
|andres || Andres Freund
|-
|Assid || Satish Alwani
|-
|aurynn || Aurynn Shaw
|-
|BlueAidan/BlueAidan_work || [[user:davidblewett | David Blewett]]
|-
|bmomjian || Bruce Momjian
|-
|cbbrowne || Christopher Browne
|-
|cce || Clark C. Evans
|-
|chicagoben || Benjamin Johnson
|-
|crab || Abhijit Menon-Sen
|-
|Crad || Gavin M. Roy
|-
|daamien || Damien Clochard
|-
|DarcyB || Darcy Buskermolen
|-
|darkixion || Thom Brown
|-
|davidfetter || David Fetter
|-
|dbb || Brian Hamlin / darkblue_b
|-
|dcolish || [http://www.unencrypted.org Dan Colish]
|-
|dcramer || Dave Cramer
|-
|DeciBull, TheCougar || Jim C. Nasby
|-
|dennisb || Dennis Björklund
|-
|depesz || Hubert Lubaczewski
|-
|devrimgunduz || Devrim Gündüz
|-
|digicon || [http://digicondev.blogspot.com Zach Conrad]
|-
|dim || Dimitri Fontaine
|-
|direvus || Brendan Jurd
|-
|drbair || Ryan Bair
|-
|DrLou || Lou Picciano
|-
|duck_tape || Adi Alurkar
|-
|dvl || [http://langille.org/ Dan Langille]
|-
|eggyknap || Joshua Tolley
|-
|endpoint_david || David Christensen
|-
|eulerto || Euler Taveira
|-
|f3ew/devdas || Devdas Vasu Bhagat
|-
|feivel || Michael Meskes
|-
|elein || Elein Mustain
|-
|gleu || Guillaume Lelarge
|-
|gorthx || [[User:Gabrielle|Gabrielle Roth]]
|-
|grzm || Michael Glaesemann
|-
|gsmet || Guillaume Smet
|-
|gregs1104 || Greg Smith
|-
|gurjeet || [[User:Gurjeet|Gurjeet Singh]]
|-
|G_SabinoMullane || Greg Sabino Mullane
|-
|HarrisonF || Harrison Fisk
|-
|ioguix || Jehan-Guillaume de Rorthais
|-
|indigo || Phil Frost
|-
|intgr || Marti Raudsepp
|-
|JanniCash || Jan Wieck
|-
|jconway || Joe Conway
|-
|jdavis, jdavis_ || Jeff Davis
|-
|jkatz05 || Jonathan S. Katz
|-
|johto || Marko Tiikkaja
|-
|jurka || Kris Jurka
|-
|justatheory || David Wheeler
|-
|jpa || Jean-Paul Argudo
|-
|jwp || James Pye
|-
|j_williams || Josh Williams
|-
|kgrittn || Kevin Grittner
|-
|klando || Cédric Villemain
|-
|larryrtx || Larry Rosenman
|-
|linuxpoet, postgresman || Joshua D. Drake
|-
|lluad || Steve Atkins
|-
|lsmith || Lukas Smith
|-
|magnush || Magnus Hagander
|-
|marco44 || Marc Cousin
|-
|markwkm || Mark Wong
|-
|mastermind || [[user:mastermind | Stefan Kaltenbrunner]]
|-
|mbalmer || [[user:mbalmer | Marc Balmer]]
|-
|merlin83 || Chua Khee Chin
|-
|merlinm || Merlin Moncure
|-
|metatrontech || Chris Travers
|-
|miracee || Susanne Ebrecht
|-
|Moosbert || Peter Eisentraut
|-
|neilc || Neil Conway
|-
|oicu || Andrew Dunstan
|-
|okbobcz || Pavel Stehule
|-
|pg_docbot || [[IRCBotSyntax]]
|-
|pgSnake || Dave Page
|-
|PJMODOS || Petr Jelínek
|-
|Possible || Robert Ivens
|-
|postwait || Theo Schlossnagle
|-
|prothid || R Brenton Strickler
|-
|psoo || Bernd Helmle
|-
|pyarra || Philip Yarra
|-
|raptelan || [[user:Cshobe|Casey Allen Shobe]]
|-
|rhaas || Robert Haas
|-
|RhodiumToad (formerly AndrewSN) || Andrew Gierth
|-
|Robe || [[user:Robe | Michael Renner]]
|-
|rotellaro || Federico Campoli
|-
|rz || Kirill Simonov
|-
|SAS || Stéphane Schildknecht
|-
|schmiddy || Josh Kupershmidt
|-
|scrappy || Marc G. Fournier
|-
|selenamarie || Selena Deckelmann
|-
|SkippyDigits || Sherri Kalm
|-
|Snow-Man || Stephen Frost
|-
|Spritz || Matteo Beccati
|-
|sternocera || Peter Geoghegan
|-
|StuckMojo, MojoWork || Jon Erdman
|-
|swm || Gavin Sherry
|-
|vy || Volkan YAZICI
|-
|wulczer || Jan Urbański
|-
|xaprb || Baron Schwartz
|-
|xzilla, xzi11a || [[User:Xzilla|Robert Treat]]
|}

[[Category:Community]]

Using EXPLAIN

Singh.gurjeet — Fri, 07 Dec 2012 12:33:35 GMT

Singh.gurjeet:

{{Languages}}
Figuring out why a statement is taking so long to execute is done with the [http://www.postgresql.org/docs/current/static/sql-explain.html EXPLAIN] command. You can run this two ways; if you use EXPLAIN ANALYZE, it will actually run the statement and let you compare what the planner thought was going to happen with what actually did. Note that if the statement changes data, that will also happen when you run with EXPLAIN ANALYZE; if you just use EXPLAIN the statement doesn't do anything to the database.

There are some tools available to help interpret EXPLAIN output:
* pgadmin includes a visual EXPLAIN tool that helps map out what's actually happening. See [http://www.postgresonline.com/journal/index.php?/archives/27-Reading-PgAdmin-Graphical-Explain-Plans.html Reading PgAdmin Graphical Explain Plans].
* Visual Explain, originally a [http://sources.redhat.com/rhdb/visualexplain.html RedHat component] that has been kept current and improved by EnterpriseDB, comes bundled with the EnterpriseDB Advanced Server package. It can be built to run against other PostgreSQL installations using the source code to their [http://www.enterprisedb.com/products/download.do Developer Studio] package.
* [http://explain.depesz.com/ explain.depesz.com] shows explain plan with extracted summarized times, and highlights based on chosen criteria.

And there are a few tutorials on this subject, many of which are titled "Explaining Explain" (sigh):
* [http://www.postgresql.org/docs/current/interactive/performance-tips.html Performance Tips]
* [http://www.gtsm.com/oscon2003/toc.html Efficient SQL] by Greg Sabino Mullane (2003)
* Explaining Explain: [http://redivi.com/~bob/oscon2005_pgsql_pdf/OSCON_Explaining_Explain_Public.pdf pdf] [http://www.postgresql.org/communityfiles/13.sxi OpenOffice Presentation] by Robert Treat (2005)
* [http://pooteeweet.org/files/phpworkso6/exlaining_explain.pdf Explaining Explain] by Lukas Smith (2006)
* [http://wiki.postgresql.org/images/4/45/Explaining_EXPLAIN.pdf Explaining Explain] by Greg Stark (2008)
* [http://neilconway.org/talks/executor.pdf Query Execution Techniques in PostgreSQL] by Neil Conway
* [[Introduction to VACUUM, ANALYZE, EXPLAIN, and COUNT]] by Jim Nasby
* [https://sites.google.com/site/robertmhaas/presentations The PostgreSQL Query Planner] by Robert Haas (2010)
* [http://www.2ndquadrant.com/books/postgresql-9-0-high-performance/ PostgreSQL 9.0 High Performance] (2010) is a book with a long discussion of how to use EXPLAIN, read the resulting query plans, and make changes to get different plans.

A common problem that causes the planner to make bad decisions is not keeping [[Planner Statistics]] updated. Another is leaving the tuning parameters that let the server know how memory is available at the very small defaults. For example, in the stock configuration, sorts that take more than 1MB are swapped to disk as being too big to process in memory. [[Tuning Your PostgreSQL Server]] covers good practices for sizing the memory and other tuning parameters that most impact query planning.

One thing you do when stumped by a plan is to submit the full EXPLAIN ANALYZE output, along with the schema of the involved queries, to the [http://archives.postgresql.org/pgsql-performance/ pgsql-performance] mailing list. To get a useful reply more quickly, please read [[SlowQueryQuestions]] before posting. Note that if you're not running a relatively current version of PostgreSQL, it's quite possible the answer you'll get is that the problem is resolved in a later one. It may save you some time to try at least the most current update to the version you're using (i.e. upgrade to 8.2.6 if that's the current latest rev and you're using 8.2.3) and see if that improves the plan you get.

An advanced technique here is to save your explain plans over time and see how they change as the amount of data in the table grows. This can give you an idea if you're collecting statistics aggressively enough. [http://people.planetpostgresql.org/greg/index.php?/archives/106-Putting-EXPLAIN-results-into-a-table.html Putting EXPLAIN results into a table] gives a technique for automating that. A simple pl/pgsql example is at [http://archives.postgresql.org/message-id/9359.1243290777@sss.pgh.pa.us generic options for explain].

[[Category:FAQ]]
[[Category:Performance]]
[[Category:PGAdmin]]

Postgres Open Talks 2011

Singh.gurjeet — Wed, 28 Sep 2011 16:10:44 GMT

Singh.gurjeet: /* Governors' Suite */

= Postgres Open Talks 2011 =

Here will be the Postgres Open talks.

== Tutorials: Wednesday September 14, 2011 ==

=== Mayfair Room ===
* [http://bunsen.credativ.com/~jco/2011/migrating.pdf Migration to PostgreSQL - preparation and methodology]
* [http://www.scribd.com/doc/65304692/Scaling-With-SkyTools Scaling With Skytools]

=== Governor's Suite ===
* [http://momjian.us/main/writings/pgsql/administration.pdf Mastering PostgreSQL Administration]

== Sessions: Thursday September 15, 2011 ==

=== Cotillion Room ===
* [http://www.pgexperts.com/document.html?id=53 Keynote: The next 25 years]
* [[Media:Nvram_fun_profit.pdf|NVRAM for Fun and Profit]]
* [http://portal.sliderocket.com/vmware/PGOpen2011_VirtEnv Running PostgreSQL on Virtualized Environments - Jignesh Shah]
* [http://wiki.postgresql.org/wiki/File:Pg_query_analysis_20110914.odp Identifying Slow Queries and Fixing Them Slides]
* [http://www.hagander.net/talks/The%20PostgreSQL%20Replication%20Protocol%20pgopen.pdf The PostgreSQL replication protocol]

=== Mayfair Room ===
* [http://wiki.postgresql.org/wiki/File:PEM_Breifing.tar.gz Introducing Postgres Enterprise Manager]
* [http://joshwilliams.name/talks/monitoring/ Monitoring the Heck out of Your Database]
* [http://www.slideshare.net/DBNess/honey-i-shrunk-the-database-9273383 Honey, I Shrunk the Database]
* [http://wiki.postgresql.org/images/0/0b/Postgresql_django_extensions.pdf Writing Django Extensions for PostgreSQL]
* [http://wiki.postgresql.org/images/8/8e/Logging.odp Logging - Not Just for Lumberjacks] (speaker notes included)
* [http://www.pgexperts.com/presentations.html PostgreSQL 9.1 Grand Tour]

=== Governors' Suite ===

* [http://heroku-postgres-talk.heroku.com/ Heroku Postgres]
* [http://wiki.postgresql.org/wiki/File:Why_you_should_not_move_away_from_Oracle.pdf Why you should NOT move away from Oracle]
* [http://bunsen.credativ.com/~mme/2011/MissionImpossible.pdf Mission impossible? Can I replace my most important databases with PostgreSQL?]
* [http://wiki.postgresql.org/images/0/0c/BillingSystemForTELCO_technical.pdf Billing System for a TELCO based on PostgreSQL - technical description]
* [[media:HP_Postgres_Insight_RS.pdf|HP Performs Large-scale Deployment of Postgres with its Remote Support Software]]

=== Michigan Demos ===

* [http://www.enterprisedb.com/resources-community/webcasts-podcasts-videos/webcasts/postgres-cloud-introduction-postgres-plus-clou Postgres In the Cloud: an Introduction to Postgres Plus Cloud Server]

== Sessions: Friday September 16, 2011 ==

=== Cotillion Room ===

* [http://wiki.postgresql.org/images/d/d3/Unlogged_Tables_Postgres_Open.odp Unlogged Tables]
* [http://momjian.us/main/writings/pgsql/locking.pdf Unlocking the Postgres Lock Manager]
* [http://www.percona.com/redir/files/presentations/POSTGRESOPEN2011-Measuring-Scalability-and-Performance-With-TCP.pdf Measuring Scalability and Performance With TCP]
* [http://bucardo.org/slides/b5_multi_master/ Bucardo Replication]
* [http://michael.otacoo.com/wp-content/uploads/2011/09/20110916_pgopen_xc.pdf Postgres-XC]

=== Mayfair Room ===
* [http://wiki.postgresql.org/images/7/79/Accelerating_Local_Search_PostgreSQL_91.pdf Accelerating Local Search With PostgreSQL 9.1]
* [http://bunsen.credativ.com/~jco/2011/plr-PostgresOpen-2011.pdf PL/R -- The Fast Path to Advanced Analytics]
* [http://wiki.postgresql.org/images/8/8a/Serializable-transactions-are-here.odp True Serializable Transactions Are Here!]

=== Michigan Room ===

* [http://wiki.postgresql.org/images/7/7c/Development_Funding.pdf Get Your Preferred Feature Developed!]
* [http://wiki.postgresql.org/images/0/0e/Center_of_your_dataverse.pdf PostgreSQL at the centre of your dataverse]
* [http://htsql.org/talks/20110916.html Advanced Query Construction with HTSQL]
* [http://wiki.postgresql.org/images/5/56/Database_sing.pdf We write the code that makes the database sing]
* [http://wiki.postgresql.org/images/f/fa/Slony_Versus_Developers.pdf Slony Versus Developers]
* [http://wiki.postgresql.org/images/7/7f/Adam-lowry-postgresopen2011.pdf Postgres at Urban Airship]

[[Category:PostgreSQL Events]]

Postgres Open Talks 2011

Singh.gurjeet — Wed, 28 Sep 2011 16:09:18 GMT

Singh.gurjeet: /* Mayfair Room */

= Postgres Open Talks 2011 =

Here will be the Postgres Open talks.

== Tutorials: Wednesday September 14, 2011 ==

=== Mayfair Room ===
* [http://bunsen.credativ.com/~jco/2011/migrating.pdf Migration to PostgreSQL - preparation and methodology]
* [http://www.scribd.com/doc/65304692/Scaling-With-SkyTools Scaling With Skytools]

=== Governor's Suite ===
* [http://momjian.us/main/writings/pgsql/administration.pdf Mastering PostgreSQL Administration]

== Sessions: Thursday September 15, 2011 ==

=== Cotillion Room ===
* [http://www.pgexperts.com/document.html?id=53 Keynote: The next 25 years]
* [[Media:Nvram_fun_profit.pdf|NVRAM for Fun and Profit]]
* [http://portal.sliderocket.com/vmware/PGOpen2011_VirtEnv Running PostgreSQL on Virtualized Environments - Jignesh Shah]
* [http://wiki.postgresql.org/wiki/File:Pg_query_analysis_20110914.odp Identifying Slow Queries and Fixing Them Slides]
* [http://www.hagander.net/talks/The%20PostgreSQL%20Replication%20Protocol%20pgopen.pdf The PostgreSQL replication protocol]

=== Mayfair Room ===
* [http://wiki.postgresql.org/wiki/File:PEM_Breifing.tar.gz Introducing Postgres Enterprise Manager]
* [http://joshwilliams.name/talks/monitoring/ Monitoring the Heck out of Your Database]
* [http://www.slideshare.net/DBNess/honey-i-shrunk-the-database-9273383 Honey, I Shrunk the Database]
* [http://wiki.postgresql.org/images/0/0b/Postgresql_django_extensions.pdf Writing Django Extensions for PostgreSQL]
* [http://wiki.postgresql.org/images/8/8e/Logging.odp Logging - Not Just for Lumberjacks] (speaker notes included)
* [http://www.pgexperts.com/presentations.html PostgreSQL 9.1 Grand Tour]

=== Governors' Suite ===

* [http://heroku-postgres-talk.heroku.com/ Heroku Postgres]
* [http://wiki.postgresql.org/images/5/58/Why_you_should_not_move_away_from_Oracle.pdf Why you should NOT move away from Oracle]
* [http://bunsen.credativ.com/~mme/2011/MissionImpossible.pdf Mission impossible? Can I replace my most important databases with PostgreSQL?]
* [http://wiki.postgresql.org/images/0/0c/BillingSystemForTELCO_technical.pdf Billing System for a TELCO based on PostgreSQL - technical description]
* [[media:HP_Postgres_Insight_RS.pdf|HP Performs Large-scale Deployment of Postgres with its Remote Support Software]]

=== Michigan Demos ===

* [http://www.enterprisedb.com/resources-community/webcasts-podcasts-videos/webcasts/postgres-cloud-introduction-postgres-plus-clou Postgres In the Cloud: an Introduction to Postgres Plus Cloud Server]

== Sessions: Friday September 16, 2011 ==

=== Cotillion Room ===

* [http://wiki.postgresql.org/images/d/d3/Unlogged_Tables_Postgres_Open.odp Unlogged Tables]
* [http://momjian.us/main/writings/pgsql/locking.pdf Unlocking the Postgres Lock Manager]
* [http://www.percona.com/redir/files/presentations/POSTGRESOPEN2011-Measuring-Scalability-and-Performance-With-TCP.pdf Measuring Scalability and Performance With TCP]
* [http://bucardo.org/slides/b5_multi_master/ Bucardo Replication]
* [http://michael.otacoo.com/wp-content/uploads/2011/09/20110916_pgopen_xc.pdf Postgres-XC]

=== Mayfair Room ===
* [http://wiki.postgresql.org/images/7/79/Accelerating_Local_Search_PostgreSQL_91.pdf Accelerating Local Search With PostgreSQL 9.1]
* [http://bunsen.credativ.com/~jco/2011/plr-PostgresOpen-2011.pdf PL/R -- The Fast Path to Advanced Analytics]
* [http://wiki.postgresql.org/images/8/8a/Serializable-transactions-are-here.odp True Serializable Transactions Are Here!]

=== Michigan Room ===

* [http://wiki.postgresql.org/images/7/7c/Development_Funding.pdf Get Your Preferred Feature Developed!]
* [http://wiki.postgresql.org/images/0/0e/Center_of_your_dataverse.pdf PostgreSQL at the centre of your dataverse]
* [http://htsql.org/talks/20110916.html Advanced Query Construction with HTSQL]
* [http://wiki.postgresql.org/images/5/56/Database_sing.pdf We write the code that makes the database sing]
* [http://wiki.postgresql.org/images/f/fa/Slony_Versus_Developers.pdf Slony Versus Developers]
* [http://wiki.postgresql.org/images/7/7f/Adam-lowry-postgresopen2011.pdf Postgres at Urban Airship]

[[Category:PostgreSQL Events]]

File:PEM Breifing.tar.gz

Singh.gurjeet — Wed, 28 Sep 2011 16:07:19 GMT

Singh.gurjeet: A short introduction to Postgres Enterprise Manager (PEM), a new product developed by EnterpriseDB. The file contains the ODP format presentation and screenshots of the product.

A short introduction to Postgres Enterprise Manager (PEM), a new product developed by EnterpriseDB. The file contains the ODP format presentation and screenshots of the product.

Postgres Open Talks 2011

Singh.gurjeet — Fri, 16 Sep 2011 16:17:55 GMT

Singh.gurjeet: /* Governors' Suite */

= Postgres Open Talks 2011 =

Here will be the Postgres Open talks.

== Tutorials: Wednesday September 14, 2011 ==

=== Mayfair Room ===
* [http://bunsen.credativ.com/~jco/2011/migrating.pdf Migration to PostgreSQL - preparation and methodology]

== Sessions: Thursday September 15, 2011 ==

=== Cotillion Room ===
* [http://www.pgexperts.com/document.html?id=53 Keynote: The next 25 years]
* [http://bonesmoses.org/presentations/nvram_fun_profit.pdf NVRAM for Fun and Profit]
* [http://wiki.postgresql.org/wiki/File:Pg_query_analysis_20110914.odp Identifying Slow Queries and Fixing Them Slides]

=== Mayfair Room ===
* [http://joshwilliams.name/talks/monitoring/ Monitoring the Heck out of Your Database]
* [http://www.slideshare.net/DBNess/honey-i-shrunk-the-database-9273383 Honey, I Shrunk the Database]
* [http://wiki.postgresql.org/wiki/File:Postgresql_django_extensions.pdf Writing Django Extensions for PostgreSQL]

=== Governors' Suite ===

* [http://heroku-postgres-talk.heroku.com/ Heroku Postgres]
* [http://wiki.postgresql.org/images/5/58/Why_you_should_not_move_away_from_Oracle.pdf Why you should NOT move away from Oracle]
* [http://bunsen.credativ.com/~mme/2011/MissionImpossible.pdf Mission impossible? Can I replace my most important databases with PostgreSQL?]

=== Michigan Demos ===

* [http://www.enterprisedb.com/resources-community/webcasts-podcasts-videos/webcasts/postgres-cloud-introduction-postgres-plus-clou Postgres In the Cloud: an Introduction to Postgres Plus Cloud Server]

== Sessions: Friday September 16, 2011 ==

=== Cotillion Room ===

* [http://michael.otacoo.com/wp-content/uploads/2011/09/20110916_pgopen_xc.pdf Postgres-XC]

=== Mayfair Room ===

=== Michigan Room ===

File:Why you should not move away from Oracle.pdf

Singh.gurjeet — Fri, 16 Sep 2011 16:17:04 GMT

Singh.gurjeet: PostgresOpen 2011 talk slides

PostgresOpen 2011 talk slides

Postgres Open Talks 2011

Singh.gurjeet — Fri, 16 Sep 2011 16:08:58 GMT

Singh.gurjeet: /* Michigan Demos */

= Postgres Open Talks 2011 =

Here will be the Postgres Open talks.

== Tutorials: Wednesday September 14, 2011 ==

=== Mayfair Room ===
* [http://bunsen.credativ.com/~jco/2011/migrating.pdf Migration to PostgreSQL - preparation and methodology]

== Sessions: Thursday September 15, 2011 ==

=== Cotillion Room ===
* [http://www.pgexperts.com/document.html?id=53 Keynote: The next 25 years]
* [http://bonesmoses.org/presentations/nvram_fun_profit.pdf NVRAM for Fun and Profit]
* [http://wiki.postgresql.org/wiki/File:Pg_query_analysis_20110914.odp Identifying Slow Queries and Fixing Them Slides]

=== Mayfair Room ===
* [http://joshwilliams.name/talks/monitoring/ Monitoring the Heck out of Your Database]
* [http://www.slideshare.net/DBNess/honey-i-shrunk-the-database-9273383 Honey, I Shrunk the Database]
* [http://wiki.postgresql.org/wiki/File:Postgresql_django_extensions.pdf Writing Django Extensions for PostgreSQL]

=== Governors' Suite ===

* [http://heroku-postgres-talk.heroku.com/ Heroku Postgres]
* [http://bunsen.credativ.com/~mme/2011/MissionImpossible.pdf Mission impossible? Can I replace my most important databases with PostgreSQL?]

=== Michigan Demos ===

* [http://www.enterprisedb.com/resources-community/webcasts-podcasts-videos/webcasts/postgres-cloud-introduction-postgres-plus-clou Postgres In the Cloud: an Introduction to Postgres Plus Cloud Server]

== Sessions: Friday September 16, 2011 ==

=== Cotillion Room ===

* [http://michael.otacoo.com/wp-content/uploads/2011/09/20110916_pgopen_xc.pdf Postgres-XC]

=== Mayfair Room ===

=== Michigan Room ===