PostgreSQL wiki - User contributions [en]

Postgres Open 2014

2014-09-23T12:13:04Z

Singh.gurjeet: /* Thursday September 18 */

Conference website: [http://postgresopen.org/2014/ PostgresOpen 2014]

Events shown for placeholding purposes. See the "Editing help" for instructions on how to add a link to your slides.

== Wednesday September 17 (Tutorials) ==
* [http://www.joeconway.com/presentations/adv_sql_and_functions.pdf Adv. SQL + Functions (Joe Conway, Stephen Frost)]
* PostGIS Introduction: Geometry, Geography, and Geocoding (Regina Obe, Leo Hsu)
* PostGIS on caffeine: Raster, Topology, and pgRouting (Regina Obe, Leo Hsu)
* Writing & Using Postgres Extensions ([http://tapoueh.org/ Dimitri Fontaine]) [http://tapoueh.org/images/confs/PostgresOpen_2014_Extension.pdf PostgresOpen_2014_Extension.pdf]
* Using the Heroku Platform (Free) (Harold Giménez) ([https://speakerdeck.com/hgmnz/heroku-tutorial Slides])
* NoSQL on ACID (Free) (Bruce Momjian)

== Thursday September 18 ==
* Sponsor Keynote (Marc Linster)

* [http://momjian.us/main/writings/pgsql/optimizer.pdf Explaining the Postgres Query Optimizer (Bruce Momjian)]
* [http://www.slideshare.net/denishpatel/postgres-in-amazon-rds-pg-open2014dpatel Postgres in Amazon RDS (Denish Patel)]
* [http://gurjeet.singh.im/presentations/HowDatabasesWorkPGOpen2014.pdf How Databases Work] - For Developers, Accidental DBAs and Managers (Gurjeet Singh)

* Scalability, Consistency, Replication, Availability and Performance (Simon Riggs)
* [https://wiki.postgresql.org/wiki/Postgres_Open_2014 The NoSQL Way In PostgreSQL (Vibhor Kumar)]
* So you're new to Postgres... (Michael Alan Brewer)

* [http://www.joeconway.com/presentations/test-pres.pdf Who's the Fairest of Them All? Postgres Interface Performance (Joe Conway)]
* What's new in PostgreSQL 9.4 (Magnus Hagander)
* [https://wiki.postgresql.org/wiki/File:Postgres_on_OpenStack.pdf Postgres on OpenStack (Dave Page)]

* Automated Performance Testing of Postgres (Greg Burek)
* Survival analysis of customer retention using Postgres, SQL and R (Gleb Arshinov)
* [http://www.slideshare.net/xenophenes/talk-39404280 The Three Musketeers: Authentication, Authorization and Accounting (Sarah Conway) ]

* On Beyond Data Types (Jonathan S. Katz)
* Supersized Postgres: Postgres-XL for OLTP and Big Data Analytics (Mason Sharp)
* [http://slides.com/danmcclain/postgresopen-2014 Use PostgreSQL, not Rails, to make Rails faster! (Dan McClain)]

== Lightning Talks ==
* Collations and Filesystem-based Copies (Matthew Kelly)
* pgcharts (Dimitri Fontaine)
* Terra Populus (David Haynes)
* DDL generator (Catherine Devlin)
* Is Your Bank ''Really'' on Acid? (Rob Treat)
* crontabber (Peter Bengtsson)
* Chelnik Update (Mark Wong)

== Friday, September 19 ==

* PostgreSQL Scale-Out at InMobi (Sivakumar)
* Row-Estimation Revelation and the Monolithic Query Syndrome (Jeff Amiel)
* Tales from the Postgres Front, and What We Can Learn (Marc Linster)

* PostgreSQL for developers ([http://tapoueh.org Dimitri Fontaine]) [http://tapoueh.org/images/confs/PostgresOpen_2014_PostgreSQL_for_Developers.pdf PostgresOpen_2014_PostgreSQL_for_Developers.pdf]
* Database Security and Audit Logging: User-Centered Security with JackDB (Sehrope Sarkuni)
* [https://rawgit.com/garysieling/postgres-immutable-data/master/index.html Immutable Data in Postgres (Gary Sieling)]

* How VACUUM works, and what to do when it doesn't (Simon Riggs)
* Heavy Duty Backup with PgBackRest (David Steele)
* [https://www.dropbox.com/s/sgp2byhckm48izk/pgopen-2014-full-PDF.pdf Migrating away from MySQL for an awesome fulltext search] ([http://www.peterbe.com Peter Bengtsson])

* PostgreSQL and Java: best practices (Álvaro Hernández)
* [[Media:collectd-graphite.pdf|Collectd and Graphite: Monitoring PostgreSQL with Style]] ([http://bonesmoses.org/ Shaun Thomas])
* [http://www.slideshare.net/citus_data/cstorefdw-columnar-storage-for-postgresql Columnar Store for PostgreSQL] (Ben Redman)

* Row Level Security (Stephen Frost)
* Holistic Database Application Tuning – Factoring UDFs in an All-new Way Grant Evans, (Henrietta Dombrovskaya)
* [http://tinyurl.com/frictionless-data-science Frictionless Data Science with Python] (Catherine Devlin)
* [http://michael.otacoo.com/content/materials/20140919_pgopen_logirep.pdf Understanding logical decoding and replication] ([http://michael.otacoo.com/ Michael Paquier])
* A Performance Comparison of Postgres on Different Storage Systems Dong Ye, Syed (Faisal Akber)
* A Quantitative Look at Partitions (john melesky)

*Sponsor Keynote (Simon Riggs)

Postgres Open 2013

2013-09-18T21:25:12Z

Singh.gurjeet: /* Wednesday September 18 */

Slides for talks will be linked here!

Events shown for placeholding purposes. See the "Editing help" for wiki formatting tips.

== Monday September 16 ==

== Tuesday September 17 ==
* [http://baumler.com/postgres/ Case Study: Converting the CATME application from MySQL to Postgres]
* Concurrency in Postgres
* [http://phaedrusdeinus.org/talks/federate_fdw/federate_fdw.pdf Federating Queries Using postgres_fdw]
* Keynote
* [http://scanningpages.files.wordpress.com/2013/09/puppet_pgopen2013.pdf Managing PostgreSQL with Puppet]
* Middleware is Dead
* My experience with embedding PostgreSQL
* [https://docs.google.com/file/d/0B2hio52iFB7AaHB0VEhaYmtZMms/edit?pli=1 New approach to resolve Object-relational impedance mismatch]
* Postgres what they really use
* [http://sourceforge.net/apps/mediawiki/postgres-xc/index.php?title=PGOpen2013_Postgres_Open_2013 Postgres-XC dynamic cluster management]
* Query Planning Gone Wrong
* Recovering from a Damaged Cluster
* [https://speakerdeck.com/selenamarie/sane-schema-management-with-alembic Sane Schema Management With Alembic]
* [http://www.slideshare.net/denishpatel/scaling-postgres Scaling Postgres]
* [http://t.co/q0dQZJg2cJ Taking Advantage of Custom Background Workers]
* What's New in PostgreSQL 9.3

=== Lightning Talks ===
* [http://tinyurl.com/pgopen2013-ipy-sql IPython Notebook: your new SQL client]
* [https://wiki.postgresql.org/images/d/d4/Json-speed-user-groups.pdf JSON, Speed, and User Groups]
* [http://www.slideshare.net/markwkm/ohai-my-name-is-chelnik-postgres-open-2013-report OHAI, my name is Chelnik!] Postgres Open 2013 Report
* [http://www.slideshare.net/denishpatel/choosing-the-d Choosing the "D"/Doctor]

== Wednesday September 18 ==
* A Comparison of PostgreSQL Encryption Options
* Geographically Distributed Parallel Databases – A Reality!
* [https://wiki.postgresql.org/wiki/File:Postgres_Is_Different_From_Better_Than_Your_RDBMS.pdf How Postgres is different from (read BETTER than) your database]
* Inside PostgreSQL Shared Memory
* JackDB - Database Development In Your Web Browser
* Multi-Database Collaboration and Extract-Transform-Load with HTSQL
* NewSQL: Leveraging PostgreSQL
* Postgres Plus Cloud Database
* [http://www.consistentstate.com/pdf/backup-and-recovery-methods.pdf PostgreSQL Backup and Recovery Methods]
* PostgreSQL on ZFS: backup, replication, disaster recovery, and more
* Replication Refresh
* Scalable Uniques in Postgres - HyperLogLog
* Secure your webapp passwords in PostgreSQL
* SQL database server Requests from the Browser
* Using JSON with Postgres 9.3
* Using Postgres FDW w/ a sharded PostgreSQL Database
* [http://www.keithf4.com/wp-content/uploads/2013/09/pg_open2013_when_pg_cant_you_can.pdf When PostgreSQL Can't, You Can]
* [http://bit.ly/1eddml6 Writing portable postgreSQL-backed network applications for the open cloud]

File:Postgres Is Different From Better Than Your RDBMS.pdf

2013-09-18T21:23:04Z

Singh.gurjeet: A presentation making case for Postgres as being ready for Enterprise-grade projects.

A presentation making case for Postgres as being ready for Enterprise-grade projects.

Postgres Open Talks 2011

2013-06-30T16:50:49Z

Singh.gurjeet: /* Governors' Suite */

= Postgres Open Talks 2011 =

Slides and links from [http://www.postgresopen.org/2011/ Postgres Open 2011]. Videos are being released to the [http://www.youtube.com/user/tcation Technocation channel] and there is a [http://www.youtube.com/playlist?list=PLAA2EB0319CDE0A0B playlist] of them all.

== 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]
* [http://www.2ndquadrant.com/static/2quad/media/pdfs/talks/char11/FastRepmgrScaling.pdf Fast Read Scaling with repmgr] - [http://www.youtube.com/watch?v=Cb0qNFmVTe0 Video]
* [[Media:Nvram_fun_profit.pdf|NVRAM for Fun and Profit]] - [http://www.youtube.com/watch?v=WstoaATaVsY Video]
* [http://portal.sliderocket.com/vmware/PGOpen2011_VirtEnv Running PostgreSQL on Virtualized Environments] - [http://www.youtube.com/watch?v=MGB2ewT5w-A Video]
* [http://wiki.postgresql.org/wiki/File:Pg_query_analysis_20110914.odp Identifying Slow Queries and Fixing Them Slides] - [http://www.youtube.com/watch?v=w6zOkxU9uRY Video]
* [http://www.hagander.net/talks/The%20PostgreSQL%20Replication%20Protocol%20pgopen.pdf The PostgreSQL replication protocol]
* [http://www.2ndquadrant.com/static/2quad/media/pdfs/talks/SyncRepDurability.pdf Synchronous Replication and Durability Tuning] - [http://www.youtube.com/watch?v=XL7j8hTd6R8 Video]

=== Mayfair Room ===
* [http://wiki.postgresql.org/wiki/File:PEM_Breifing.tar.gz Introducing Postgres Enterprise Manager] - [http://www.youtube.com/watch?v=jmKzDH4APxM Video]
* [http://joshwilliams.name/talks/monitoring/ Monitoring the Heck out of Your Database] - [http://www.youtube.com/watch?v=z7ypB0P1B30 Video]
* [http://www.slideshare.net/DBNess/honey-i-shrunk-the-database-9273383 Honey, I Shrunk the Database] - [http://www.youtube.com/watch?v=ohe9gDLBhjk Video]
* [http://wiki.postgresql.org/images/0/0b/Postgresql_django_extensions.pdf Writing Django Extensions for PostgreSQL] - [http://www.youtube.com/watch?v=4YZtxmmsD2o Video], [http://www.youtube.com/watch?v=aNnlY8unSQk Part 2]
* [http://wiki.postgresql.org/images/8/8e/Logging.odp Logging - Not Just for Lumberjacks] (speaker notes included) - [http://www.youtube.com/watch?v=OVE1j5RyJ5A Video]
* PL/Java Tutorial - [http://www.youtube.com/watch?v=5iRqqvT1qSE Video]
=== 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://www.youtube.com/watch?v=zYOFUmuvok4 Video]
* [http://bunsen.credativ.com/~mme/2011/Postgres_Open.pdf Mission impossible? Can I replace my most important databases with PostgreSQL?] - [http://www.youtube.com/watch?v=otCfbGApoBc Video]
* [http://wiki.postgresql.org/images/0/0c/BillingSystemForTELCO_technical.pdf Billing System for a TELCO based on PostgreSQL]
* [[media:HP_Postgres_Insight_RS.pdf|HP Performs Large-scale Deployment of Postgres with its Remote Support Software]] - [http://www.youtube.com/watch?v=0TzraoszmCA Video]
* [http://www.pgexperts.com/presentations.html PostgreSQL 9.1 Grand Tour] - [http://www.youtube.com/watch?v=XsHCU6R7ato Video]

=== 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 ===

* VMWare Keynote - [http://www.youtube.com/watch?v=DTX3-gQ6uuI Video]
* [http://wiki.postgresql.org/images/d/d3/Unlogged_Tables_Postgres_Open.odp Unlogged Tables] - [http://www.youtube.com/watch?v=uM0E4Qag_PU Video]
* [http://momjian.us/main/writings/pgsql/locking.pdf Unlocking the Postgres Lock Manager] - [http://www.youtube.com/watch?v=s3ee0nuDDqs Video]
* [http://www.percona.com/redir/files/presentations/POSTGRESOPEN2011-Measuring-Scalability-and-Performance-With-TCP.pdf Measuring Scalability and Performance With TCP] - [http://www.youtube.com/watch?v=FS7Zq1w7SDo Video]
* [http://bucardo.org/slides/b5_multi_master/ Bucardo Replication] - [http://www.youtube.com/watch?v=mGu1WB5q30E Video]
* [http://michael.otacoo.com/wp-content/uploads/2011/09/20110916_pgopen_xc.pdf Postgres-XC] - [http://www.youtube.com/watch?v=ya6WvkH4fLM Video]

=== Mayfair Room ===
* [http://wiki.postgresql.org/images/7/79/Accelerating_Local_Search_PostgreSQL_91.pdf Accelerating Local Search With PostgreSQL 9.1] - [http://www.youtube.com/watch?v=N-MD08QqGEM Video]
* Managing Databases in a DevOps Environment - [http://www.youtube.com/watch?v=XE69W7gc3n0 Video]
* [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!] - [http://www.youtube.com/watch?v=wb6ULamJI9E Video]

=== Michigan Room ===

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

[[Category:PostgreSQL Events]]

User:Singh.gurjeet

2013-01-02T17:50:05Z

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

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

IRC2RWNames

2013-01-02T17:48:21Z

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

2013-01-02T17:47:10Z

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

2012-12-07T12:33:35Z

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

2011-09-28T16:10:44Z

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

2011-09-28T16:09:18Z

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

2011-09-28T16:07:19Z

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

2011-09-16T16:17:55Z

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

2011-09-16T16:17:04Z

Singh.gurjeet: PostgresOpen 2011 talk slides

PostgresOpen 2011 talk slides

Postgres Open Talks 2011

2011-09-16T16:08:58Z

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 ===