https://wiki.postgresql.org/api.php?action=feedcontributions&user=Denish&feedformat=atomPostgreSQL wiki - User contributions [en]2024-03-19T03:17:56ZUser contributionsMediaWiki 1.35.13https://wiki.postgresql.org/index.php?title=Postgres_Open_2016&diff=28182Postgres Open 20162016-09-15T15:42:05Z<p>Denish: /* Thursday, September 15 */</p>
<hr />
<div>Conference website: [http://2016.postgresopen.org/ PostgresOpen 2016]<br />
<br />
[https://postgresopen.org/events/feedback/pgopen2016/ Conference Feedback]<br />
<br />
Events shown for placeholding purposes. See the "Editing help" for instructions on how to add a link to your slides.<br />
<br />
== Tuesday September 13 (Tutorials) ==<br />
* Introduction to PostGIS (Regina Obe and Leo Hsu)<br />
* Seamless failover with pgBouncer and Consul (Scott Mead)<br />
* Linux tuning to improve PostgreSQL performance: from hardware to postgresql.conf (Ilya Kosmodemiansky)<br />
* Advanced SQL + Functions (Joe Conway, Stephen Frost)<br />
* Autoscaling PostgreSQL with Kubernetes and OpenShift Part 1 (Jeff McCormick, Steven Pousty)<br />
<br />
== Wednesday September 14 ==<br />
* Digital Service Expert at the United States Digital Service, @USDS keynote (Marianne Bellotti)<br />
<br />
* A Look at the Elephant's Tail (Greg Stark)<br />
* A look at the Elephants trunk - PostgreSQL 9.6 (Magnus Hagander)<br />
* Flexible Indexing with Postgres (Bruce Momjian)<br />
* CREATE INDEX ... USING RUM. RUM index and its applications to FTS. (Oleg Bartunov)<br />
* Locked Up: Advances in Postgres Data Encryption (Vibhor Kumar)<br />
* [http://www.slideshare.net/SeanChittenden/dynamic-database-credentials-security-contingency-planning Assume database credentials have leaked: Dynamic Database credentials...] (Sean Chittenden) ([https://github.com/sean-/pgopen16-dyn-creds GitHub demo material])<br />
* You'd better have tested backups... (Dimitri Fontaine)<br />
* The Elephant Meets the Whale - Bringing PostgreSQL to Production on Docker (Phil Vacca)<br />
* Reviewing PostgreSQL Patches for Fun and Profit (David Steele)<br />
* Does Anybody Really Know What Time It Is? (Michael Alan Brewer)<br />
* PGLogical - the logical replication for PostgreSQL (Petr Jelinek)<br />
* Shall We Play a Game? (with CTEs) (James Coleman)<br />
* Performance Improvements in PostgreSQL 9.5, 9.6 and beyond (Tomas Vondra)<br />
* All the Big Data Sciency stuff you never knew Postgres could do (Jim Nasby)<br />
* Using PostGIS to Handle Geospatial Data as Vectors and Rasters (Dylan Herron)<br />
<br />
== Lightning Talks ==<br />
* etc etc<br />
<br />
== Thursday, September 15 ==<br />
<br />
* [http://www.pateldenish.com/2016/09/advanced-postgres-monitoring.html Advanced Postgres Monitoring] (Denish Patel)<br />
* An opinionated guide to PostgreSQL replication (Peter Eisentraut)<br />
* Amazon RDS for PostgreSQL: New Features and Lessons Learned (Grant McAlister)<br />
* PostgreSQL Backups the modern ways (Magnus Hagander)<br />
* Big Data with PostgreSQL (Simon Riggs)<br />
* PostgreSQL worst practices (Ilya Kosmodemiansky)<br />
* Using PostgreSQL in a Small Business (Preston Hagar)<br />
* Administering Postgres using Docker and Openshift (Jeff McCormick)<br />
* Permissions in Postgres (Nathan Wagner)<br />
* Elephant Herd as a Service: Managing Hundreds of Postgres Instances (Shaun Thomas)<br />
* Managing OS Provided PostgreSQL Packages (Keith Fiske)<br />
* Data Architecture with PostgreSQL (Kevin Kempter)<br />
* Bitemporal Data Model: making it happened in Postgres (Henrietta Dombrovskaya)<br />
* Understanding Durability in Postgres (Andres Freund)<br />
* PostgreSQL with Chef & Puppet (Scott Mead)<br />
* Data Analysis with PL/Python (Keith Robertson)<br />
* JDBC performance from the inside (Dave Cramer)<br />
* Growing with your Data (Richard Silva)</div>Denishhttps://wiki.postgresql.org/index.php?title=PgConfUS_Talks_2016&diff=27484PgConfUS Talks 20162016-04-28T14:59:55Z<p>Denish: </p>
<hr />
<div>= PGConf US 2016 Talks =<br />
<br />
== Conference Website ==<br />
<br />
http://www.pgconf.us/2016/<br />
<br />
== Videos ==<br />
<br />
https://www.youtube.com/pgconfus/<br />
<br />
== Trainings: Monday, 18 Apr 2016 ==<br />
<br />
* PostgreSQL When It is Not Your Job, Christophe Pettus<br />
* Linux tuning to improve PostgreSQL performance: from hardware to postgresql.conf, Ilya Kosmodemiansky<br />
* Steel Elephant: A Highly Secure PostgreSQL Environment with HashiCorp's Vault and Consul, Sean Chittenden<br />
* Introduction to PostGIS, Leo Hsu and Regina Obe<br />
* [http://www.slideshare.net/denishpatel/out-of-the-box-replication-in-postgres-94pg-confus Out of the Box Replication in PostgreSQL 9.4] , Denish Patel<br />
* Elevating Your Confidence with PostgreSQL's Restoration Capabilities!, Joshua D. Drake<br />
<br />
== Regulated Industry Summit: Monday, 18 Apr 2016 ==<br />
<br />
* State of Encryption, Privacy and Architecting for Scale, Will Ackerly, Founder, CTO, Virtru<br />
* Panel: Security, Compliance and IoT<br />
* Ideology and Licensing of Free and Open Source Software, Karen Sandler, Executive Director, Software Freedom Conservancy<br />
* Regulated Industries - Overview of New Drug Development and its Data Challenges, Dr. David P. Katz, Director - Life Sciences, KPMG<br />
* Healthcare & Regulations, Michael Ebert, Partner - Cyber Practice, KPMG<br />
* Roundtable: Can PostgreSQL become the world’s most advanced "enterprise" database?, PostgreSQL Core Team / Major Contributors<br />
* Panel: Modern Data Management for Enterprises, Bridging the SQL/NoSQL divide, Perspectives from MongoDB, PostgreSQL, Compose.io<br />
<br />
== Sessions: Tuesday, 19 Apr 2016 ==<br />
<br />
=== Grand Ballroom Salon A ===<br />
<br />
* Lessons Learned Operating Postgres at Scale, Dave Pirotte<br />
* An Availability Journey with MasterCard and PostgreSQL, John Young<br />
* [https://speakerdeck.com/lfittl/postgresql-at-a-web-startup Practical Lessons Learned when using PostgreSQL at a Web Startup], Lukas Fittl<br />
* [https://speakerdeck.com/pteodoro/esasky-new-window-to-the-universe ESA Sky: New window to the stars using PostgreSQL], Pilar de Teodoro<br />
* PostgreSQL in the Polyglot Enterprise, Mitch Pirtle<br />
<br />
=== Grand Ballroom Salon B ===<br />
<br />
* PostgreSQL Monitoring, Kevin Kempter<br />
* HawkEye On Postgresql, Adarsh Sharma<br />
* PostgreSQL High-Availability and Geographic Locality using consul, Sean Chittenden<br />
* Amazon RDS for PostgreSQL - Deep Dive on New Features and Learnings, Grant McAlister<br />
* HA PostgreSQL cluster with repmgr and pgbouncer, Jaime Casanova<br />
<br />
=== Grand Ballroom Salon C ===<br />
<br />
* PostgreSQL & Java: past, present and future, Alvaro Hernandez<br />
* [http://www.postgis.us/presentations/PGConfUS2016_PostGISTop10.pdf Top 10 Problems Solved by PostGIS], Leo Hsu and Regina Obe<br />
* Overcoming First Principles: A guide for accessing the features of PostgreSQL in test-driven development, Eric Radman<br />
* PubSub with Postgresql, Gian Biondi<br />
* [https://www.dropbox.com/sh/7jcmk7mp2qz0tho/AAC89g8PDayuVEAn3iEBbQtMa?dl=0 Predictive Analytics IN Postgres], [https://www.linkedin.com/in/decibel Jim Nasby]<br />
<br />
=== Northside Ballroom ===<br />
<br />
* PostgreSQL Development, Simon Riggs<br />
* How PostgreSQL is tested, Peter Eisentraut<br />
* Citus Architecture: Extending Postgres to Build a Distributed Database, Ozgun Erdogan<br />
* [http://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-60849690 Deep dive into PostgreSQL statistics], Alexey Lesovsky<br />
* Sorting Through the Ages, Gregory Stark<br />
<br />
== Keynotes ==<br />
<br />
* Opening Keynote - Parag Goradia, Executive Director, Cloud Services Engineering, General Electric Digital<br />
* EnterpriseDB and Open Source, Robert Haas, Chief Database Architect, EnterpriseDB<br />
* BigSQL.org - The Best Way to Get Your PostgreSQL On, David Rader, Partner & VP Product Engineering, OpenSCG<br />
* Citus and the Cloud, Umur Cubukcu, CEO & Founder and Will Leinweber, Engineer at Citus Data<br />
* Hidden in the Docs: Connection Tunable Write Consistency, Chris Winslett, Platform Engineer, Compose<br />
<br />
== Sessions: Wednesday, 20 Apr 2016 ==<br />
<br />
=== Grand Ballroom Salon A ===<br />
<br />
* Using PostgreSQL to manage ArcGIS spatial data - Taking PostgreSQL and Analytics to the Next Level with Pythonm, Chaula Jain, Andy Eschbacher<br />
* Data Integration in the World of Microservices, Valentine Gogichashvili<br />
* On Providing Scalable Managed PostgreSQL services to Cloud Foundry, Xiujiao Gao<br />
* How Tencent uses Postgres-XC for their high volume WeChat payment system, Jasonys Li<br />
* [[Media:PGConfUS2016_Migrating_a_live_Postgres_database_into_RDS_with_no_downtime.pdf|Migrating a live Postgres database into RDS with no downtime: Experiences and Lessons Learned]], David Benoit<br />
* PostgreSQL HA Database Clusters through Containment, Quan-Ha Le<br />
<br />
=== Grand Ballroom Salon B ===<br />
<br />
* PostgreSQL DevOps with Chef & Puppet, Scott Mead<br />
* Achieving a State of Flow: Continuous Integration and Practical Event Sourcing w/ PostgreSQL, Paolo Lim<br />
* Kicking the Donkey of PostgreSQL Replication, Joshua D. Drake<br />
* [http://www.pgbackrest.org/media/slide/pgBackRest-PGConfUS-2016.pdf Efficiently Backing up Terabytes of Data with pgBackRest], David Steele<br />
* [http://tapoueh.org//images/confs/PGDAY_NYC_2016_backup.pdf You'd better have tested backups], [http://tapoueh.org Dimitri Fontaine]<br />
* [https://gauss.credativ.com/~mme/2016/PGConfUS_2016_V01.pdf PostgreSQL Power on Power], Michael Meskes<br />
<br />
=== Grand Ballroom Salon C ===<br />
<br />
* [http://www.joeconway.com/presentations/mls-postgres-pgconf.us-2016.pdf MLS PostgreSQL: Implementing Multi-level Security in PostgreSQL with RLS and SELinux], Joe Conway<br />
* [[Media:Ranges,_Partitioning_and_Limitations.pdf|Ranges, Partitioning and Limitations]], Corey Huinker<br />
* That SQL looks pretty complicated. Where are the tests?, James E. Marca<br />
* PostgreSQL’s secret NoSQL superpowers, Amanda Gilmore<br />
* Programming the SQL Way with Common Table Expressions, Bruce Momjian<br />
* Deploying and Managing PostgreSQL with Ansible, David Hollenberger<br />
<br />
=== Northside Ballroom ===<br />
<br />
* SQL and MongoDB: how PostgreSQL brought them together, Asya Kamsky<br />
* How we made Greenplum Open Source, Andreas Scherbaum<br />
* Parallel Query In PostgreSQL, Robert Haas<br />
* [http://anarazel.de/talks/pgconf-nyc-2016-04-20/io.pdf IO in Postgres - Architecture, Tuning, Problems], Andres Freund<br />
* PostgreSQL Performance Presentation, 9.6devel Edition, Mark Wong<br />
* [http://www.hagander.net/talks/PostgreSQL_9.6.pdf A look at the Elephants trunk - PostgreSQL 9.6], Magnus Hagander<br />
<br />
== Lightning Talks ==<br />
<br />
* [http://tapoueh.org/images/confs/PGDAY_NYC_2016_pgloader.pdf pgloader], [http://tapoueh.org Dimitri Fontaine]</div>Denishhttps://wiki.postgresql.org/index.php?title=Postgres_Open_2014&diff=23213Postgres Open 20142014-09-22T20:02:11Z<p>Denish: /* Thursday September 18 */ Added Amazon RDS talk</p>
<hr />
<div>Conference website: [http://postgresopen.org/2014/ PostgresOpen 2014]<br />
<br />
Events shown for placeholding purposes. See the "Editing help" for instructions on how to add a link to your slides.<br />
<br />
== Wednesday September 17 (Tutorials) ==<br />
* Adv. SQL + Functions (Joe Conway, Stephen Frost)<br />
* PostGIS Introduction: Geometry, Geography, and Geocoding (Regina Obe, Leo Hsu)<br />
* PostGIS on caffeine: Raster, Topology, and pgRouting (Regina Obe, Leo Hsu)<br />
* Writing & Using Postgres Extensions ([http://tapoueh.org/ Dimitri Fontaine]) [http://tapoueh.org/images/confs/PostgresOpen_2014_Extension.pdf PostgresOpen_2014_Extension.pdf]<br />
* Using the Heroku Platform (Free) (Harold Giménez) ([https://speakerdeck.com/hgmnz/heroku-tutorial Slides])<br />
* NoSQL on ACID (Free) (Bruce Momjian)<br />
<br />
== Thursday September 18 ==<br />
* Sponsor Keynote (Marc Linster)<br />
<br />
* [http://momjian.us/main/writings/pgsql/optimizer.pdf Explaining the Postgres Query Optimizer (Bruce Momjian)]<br />
* [http://www.slideshare.net/denishpatel/postgres-in-amazon-rds-pg-open2014dpatel Postgres in Amazon RDS (Denish Patel)]<br />
* How Databases Work - For Developers, Accidental DBAs and Managers (Gurjeet Singh)<br />
<br />
* Scalability, Consistency, Replication, Availability and Performance (Simon Riggs)<br />
* The NoSQL Way In PostgreSQL (Vibhor Kumar)<br />
* So you're new to Postgres... (Michael Alan Brewer)<br />
<br />
* Who's the Fairest of Them All? Postgres Interface Performance (Joe Conway)<br />
* What's new in PostgreSQL 9.4 (Magnus Hagander)<br />
* Postgres on OpenStack (Dave Page)<br />
<br />
* Automated Performance Testing of Postgres (Greg Burek)<br />
* Survival analysis of customer retention using Postgres, SQL and R (Gleb Arshinov)<br />
* The Three Musketeers (Authentication, Authorization, and Accounting) (Sarah Conway)<br />
<br />
* On Beyond Data Types (Jonathan S. Katz)<br />
* Supersized Postgres: Postgres-XL for OLTP and Big Data Analytics (Mason Sharp)<br />
* [http://slides.com/danmcclain/postgresopen-2014 Use PostgreSQL, not Rails, to make Rails faster! (Dan McClain)]<br />
<br />
== Lightning Talks ==<br />
* Collations and Filesystem-based Copies (Matthew Kelly)<br />
* pgcharts (Dimitri Fontaine)<br />
* Terra Populus (David Haynes)<br />
* DDL generator (Catherine Devlin)<br />
* Is Your Bank ''Really'' on Acid? (Rob Treat)<br />
* crontabber (Peter Bengtsson)<br />
* Chelnik Update (Mark Wong)<br />
<br />
== Friday, September 19 ==<br />
<br />
* PostgreSQL Scale-Out at InMobi (Sivakumar)<br />
* Row-Estimation Revelation and the Monolithic Query Syndrome (Jeff Amiel)<br />
* Tales from the Postgres Front, and What We Can Learn (Marc Linster)<br />
<br />
* 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]<br />
* Database Security and Audit Logging: User-Centered Security with JackDB (Sehrope Sarkuni)<br />
* [https://rawgit.com/garysieling/postgres-immutable-data/master/index.html Immutable Data in Postgres (Gary Sieling)]<br />
<br />
* How VACUUM works, and what to do when it doesn't (Simon Riggs)<br />
* Heavy Duty Backup with PgBackRest (David Steele)<br />
* [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])<br />
<br />
* PostgreSQL and Java: best practices (Álvaro Hernández)<br />
* [[Media:collectd-graphite.pdf|Collectd and Graphite: Monitoring PostgreSQL with Style]] ([http://bonesmoses.org/ Shaun Thomas])<br />
* Columnar Store for PostgreSQL (Ben Redman)<br />
<br />
* Row Level Security (Stephen Frost)<br />
* Holistic Database Application Tuning – Factoring UDFs in an All-new Way Grant Evans, (Henrietta Dombrovskaya)<br />
* [http://tinyurl.com/frictionless-data-science Frictionless Data Science with Python] (Catherine Devlin)<br />
* [http://michael.otacoo.com/content/materials/20140919_pgopen_logirep.pdf Understanding logical decoding and replication] ([http://michael.otacoo.com/ Michael Paquier])<br />
* A Performance Comparison of Postgres on Different Storage Systems Dong Ye, Syed (Faisal Akber)<br />
* A Quantitative Look at Partitions (john melesky)<br />
<br />
*Sponsor Keynote (Simon Riggs)</div>Denishhttps://wiki.postgresql.org/index.php?title=PGConf_NYC_2014_Talks&diff=22061PGConf NYC 2014 Talks2014-04-03T19:16:56Z<p>Denish: /* Grand Ballroom Salon C */ PCI talk</p>
<hr />
<div>= PGConf NYC 2014 Talks =<br />
<br />
== Conference Website ==<br />
<br />
http://nyc.pgconf.us/2014<br />
<br />
== Talks: Thursday April 3, 2014 ==<br />
<br />
=== Grand Ballroom Salon A&B ===<br />
<br />
[http://nbviewer.ipython.org/gist/nyamada/9946705 Using Postgres for append-only immutable data]<br />
<br />
=== Grand Ballroom Salon C ===<br />
[https://wiki.postgresql.org/wiki/File:Achieving_PCI_Compliace_PgConfNYC2014.pdf Achieving PCI compliance with Postgres]<br />
<br />
=== Empire Room ===<br />
[https://wiki.postgresql.org/wiki/File:Pgconfnyc2014_whenpgcantyoucan.pdf When PostgreSQL Can't, You Can]<br />
<br />
== Talks: Friday April 4, 2014 ==<br />
<br />
=== Grand Ballroom Salon A&B ===<br />
<br />
=== Grand Ballroom Salon C ===<br />
<br />
=== Empire Room ===</div>Denishhttps://wiki.postgresql.org/index.php?title=File:Achieving_PCI_Compliace_PgConfNYC2014.pdf&diff=22059File:Achieving PCI Compliace PgConfNYC2014.pdf2014-04-03T19:15:09Z<p>Denish: Presented at Pg Conf NYC 2014</p>
<hr />
<div>== Summary ==<br />
Presented at Pg Conf NYC 2014<br />
== Licensing ==<br />
{{The PostgreSQL Licence}}</div>Denishhttps://wiki.postgresql.org/index.php?title=Postgres_Open_2013&diff=20793Postgres Open 20132013-09-18T18:46:02Z<p>Denish: /* Lightning Talks */</p>
<hr />
<div>Slides for talks will be linked here!<br />
<br />
Events shown for placeholding purposes. See the "Editing help" for wiki formatting tips.<br />
<br />
== Monday September 16 ==<br />
<br />
<br />
== Tuesday September 17 ==<br />
* [http://baumler.com/postgres/ Case Study: Converting the CATME application from MySQL to Postgres]<br />
* Concurrency in Postgres<br />
* [http://phaedrusdeinus.org/talks/federate_fdw/federate_fdw.pdf Federating Queries Using postgres_fdw]<br />
* Keynote<br />
* [http://scanningpages.files.wordpress.com/2013/09/puppet_pgopen2013.pdf Managing PostgreSQL with Puppet]<br />
* Middleware is Dead<br />
* My experience with embedding PostgreSQL<br />
* [https://docs.google.com/file/d/0B2hio52iFB7AaHB0VEhaYmtZMms/edit?pli=1 New approach to resolve Object-relational impedance mismatch]<br />
* Postgres what they really use<br />
* [http://sourceforge.net/apps/mediawiki/postgres-xc/index.php?title=PGOpen2013_Postgres_Open_2013 Postgres-XC dynamic cluster management]<br />
* Query Planning Gone Wrong<br />
* Recovering from a Damaged Cluster<br />
* [https://speakerdeck.com/selenamarie/sane-schema-management-with-alembic Sane Schema Management With Alembic]<br />
* [http://www.slideshare.net/denishpatel/scaling-postgres Scaling Postgres]<br />
* [http://t.co/q0dQZJg2cJ Taking Advantage of Custom Background Workers]<br />
* What's New in PostgreSQL 9.3<br />
<br />
=== Lightning Talks ===<br />
* [http://tinyurl.com/pgopen2013-ipy-sql IPython Notebook: your new SQL client]<br />
* [https://wiki.postgresql.org/images/d/d4/Json-speed-user-groups.pdf JSON, Speed, and User Groups]<br />
* [http://www.slideshare.net/markwkm/ohai-my-name-is-chelnik-postgres-open-2013-report OHAI, my name is Chelnik!] Postgres Open 2013 Report<br />
* [http://www.slideshare.net/denishpatel/choosing-the-d Choosing the "D"/Doctor]<br />
<br />
== Wednesday September 18 ==<br />
* A Comparison of PostgreSQL Encryption Options<br />
* Geographically Distributed Parallel Databases – A Reality!<br />
* How Postgres is different from (read BETTER than) your database<br />
* Inside PostgreSQL Shared Memory<br />
* JackDB - Database Development In Your Web Browser<br />
* Multi-Database Collaboration and Extract-Transform-Load with HTSQL<br />
* NewSQL: Leveraging PostgreSQL<br />
* Postgres Plus Cloud Database<br />
* [http://www.consistentstate.com/pdf/backup-and-recovery-methods.pdf PostgreSQL Backup and Recovery Methods]<br />
* PostgreSQL on ZFS: backup, replication, disaster recovery, and more<br />
* Replication Refresh<br />
* Scalable Uniques in Postgres - HyperLogLog<br />
* Secure your webapp passwords in PostgreSQL<br />
* SQL database server Requests from the Browser<br />
* Using JSON with Postgres 9.3<br />
* Using Postgres FDW w/ a sharded PostgreSQL Database<br />
* When PostgreSQL Can't, You Can<br />
* [http://bit.ly/1eddml6 Writing portable postgreSQL-backed network applications for the open cloud]</div>Denishhttps://wiki.postgresql.org/index.php?title=Postgres_Open_2013&diff=20792Postgres Open 20132013-09-18T18:43:12Z<p>Denish: /* Tuesday September 17 */ Adding scaling postgres presentation</p>
<hr />
<div>Slides for talks will be linked here!<br />
<br />
Events shown for placeholding purposes. See the "Editing help" for wiki formatting tips.<br />
<br />
== Monday September 16 ==<br />
<br />
<br />
== Tuesday September 17 ==<br />
* [http://baumler.com/postgres/ Case Study: Converting the CATME application from MySQL to Postgres]<br />
* Concurrency in Postgres<br />
* [http://phaedrusdeinus.org/talks/federate_fdw/federate_fdw.pdf Federating Queries Using postgres_fdw]<br />
* Keynote<br />
* [http://scanningpages.files.wordpress.com/2013/09/puppet_pgopen2013.pdf Managing PostgreSQL with Puppet]<br />
* Middleware is Dead<br />
* My experience with embedding PostgreSQL<br />
* [https://docs.google.com/file/d/0B2hio52iFB7AaHB0VEhaYmtZMms/edit?pli=1 New approach to resolve Object-relational impedance mismatch]<br />
* Postgres what they really use<br />
* [http://sourceforge.net/apps/mediawiki/postgres-xc/index.php?title=PGOpen2013_Postgres_Open_2013 Postgres-XC dynamic cluster management]<br />
* Query Planning Gone Wrong<br />
* Recovering from a Damaged Cluster<br />
* [https://speakerdeck.com/selenamarie/sane-schema-management-with-alembic Sane Schema Management With Alembic]<br />
* [http://www.slideshare.net/denishpatel/scaling-postgres Scaling Postgres]<br />
* [http://t.co/q0dQZJg2cJ Taking Advantage of Custom Background Workers]<br />
* What's New in PostgreSQL 9.3<br />
<br />
=== Lightning Talks ===<br />
* [http://tinyurl.com/pgopen2013-ipy-sql IPython Notebook: your new SQL client]<br />
* [https://wiki.postgresql.org/images/d/d4/Json-speed-user-groups.pdf JSON, Speed, and User Groups]<br />
* [http://www.slideshare.net/markwkm/ohai-my-name-is-chelnik-postgres-open-2013-report OHAI, my name is Chelnik!] Postgres Open 2013 Report<br />
<br />
== Wednesday September 18 ==<br />
* A Comparison of PostgreSQL Encryption Options<br />
* Geographically Distributed Parallel Databases – A Reality!<br />
* How Postgres is different from (read BETTER than) your database<br />
* Inside PostgreSQL Shared Memory<br />
* JackDB - Database Development In Your Web Browser<br />
* Multi-Database Collaboration and Extract-Transform-Load with HTSQL<br />
* NewSQL: Leveraging PostgreSQL<br />
* Postgres Plus Cloud Database<br />
* [http://www.consistentstate.com/pdf/backup-and-recovery-methods.pdf PostgreSQL Backup and Recovery Methods]<br />
* PostgreSQL on ZFS: backup, replication, disaster recovery, and more<br />
* Replication Refresh<br />
* Scalable Uniques in Postgres - HyperLogLog<br />
* Secure your webapp passwords in PostgreSQL<br />
* SQL database server Requests from the Browser<br />
* Using JSON with Postgres 9.3<br />
* Using Postgres FDW w/ a sharded PostgreSQL Database<br />
* When PostgreSQL Can't, You Can<br />
* [http://bit.ly/1eddml6 Writing portable postgreSQL-backed network applications for the open cloud]</div>Denishhttps://wiki.postgresql.org/index.php?title=Postgres_Open_2012&diff=18243Postgres Open 20122012-09-19T18:45:41Z<p>Denish: /* Wednesday September 19 */</p>
<hr />
<div>Slides for talks will be linked here!<br />
<br />
== Tuesday September 18 ==<br />
<br />
* [https://wiki.postgresql.org/images/7/73/Range-types-pgopen-2012.pdf Range Types in PostgreSQL 9.2 - Your Life Will Never Be the Same]<br />
* Scaling out by distributing and replicating data in Postgres-XC<br />
* PostgreSQL When It's Not Your Job<br />
<br />
* Large Scale MySQL Migration to PostgreSQL <br />
* Choosing a logical replication system: Slony vs Bucardo<br />
* Temporal Database Demo<br />
<br />
* 12 Calm Years of PostgreSQL in Critical Messaging<br />
* PostgreSQL in the cloud: Theory and Practice<br />
* [http://www.hagander.net/talks/Backup%20strategies.pdf PostgreSQL Backup Strategies]<br />
<br />
* This Is PostGIS<br />
* Embracing the Web with JSON and PLV8<br />
* How Akiban Implemented a New Database Compatible with the PostgreSQL Protocol<br />
<br />
* [[Media:Ha_postgres.pdf|High Availability with PostgreSQL and Pacemaker]]<br />
* Logging: Not Just for Lumberjacks<br />
* [http://stuff.coffeecode.net/2012/pgopen_fulltext/pgsql-fulltext-intro.html Full-text search - seek and ye shall find]<br />
<br />
=== Lightning Talks ===<br />
<br />
TBD!<br />
<br />
== Wednesday September 19 ==<br />
<br />
* [http://pgexperts.com/document.html?id=54 Super Jumbo Deluxe], plus [http://pgexperts.com/presentations.html more presentations here]<br />
* [[Media:OO_approach.pdf|An object oriented approach to data driven software development]]<br />
* TransLattice Elastic Database Architecture Deep Dive<br />
<br />
* [http://www.pateldenish.com/2012/04/deploying-maximum-ha-architecture-with-postgresql.html Deploying maximum HA architecture with Postgres] , for pg_reorg [http://static.slidesharecdn.com/swf/ssplayer2.swf?doc=p90xyourdatabase-13010796913746-phpapp02&stripped_title=p90-x-your-database p90x talk]<br />
* Scaling Postgres with some help from Redis<br />
* Retail DDL<br />
<br />
* Query Logging and Workload Analysis<br />
* A Shared-nothing cluster system: Postgres-XC<br />
* DVDStore Benchmark and PostgreSQL<br />
<br />
* Performance Improvements in PostgreSQL 9.2<br />
* A Batch of Commit Batching<br />
* [http://momjian.us/main/presentations/features.html#cte Programming the SQL Way with Common Table Expressions]<br />
<br />
* Postgres is the new default – how we transitioned our platform at Engine Yard and why you should too<br />
* Leveraging PLV8 in Javascript-heavy Web Applications<br />
* PG Extractor - A smarter pg_dump</div>Denishhttps://wiki.postgresql.org/index.php?title=Postgres_Open_2012&diff=18242Postgres Open 20122012-09-19T18:43:51Z<p>Denish: /* Wednesday September 19 */ denish's talk</p>
<hr />
<div>Slides for talks will be linked here!<br />
<br />
== Tuesday September 18 ==<br />
<br />
* [https://wiki.postgresql.org/images/7/73/Range-types-pgopen-2012.pdf Range Types in PostgreSQL 9.2 - Your Life Will Never Be the Same]<br />
* Scaling out by distributing and replicating data in Postgres-XC<br />
* PostgreSQL When It's Not Your Job<br />
<br />
* Large Scale MySQL Migration to PostgreSQL <br />
* Choosing a logical replication system: Slony vs Bucardo<br />
* Temporal Database Demo<br />
<br />
* 12 Calm Years of PostgreSQL in Critical Messaging<br />
* PostgreSQL in the cloud: Theory and Practice<br />
* [http://www.hagander.net/talks/Backup%20strategies.pdf PostgreSQL Backup Strategies]<br />
<br />
* This Is PostGIS<br />
* Embracing the Web with JSON and PLV8<br />
* How Akiban Implemented a New Database Compatible with the PostgreSQL Protocol<br />
<br />
* [[Media:Ha_postgres.pdf|High Availability with PostgreSQL and Pacemaker]]<br />
* Logging: Not Just for Lumberjacks<br />
* [http://stuff.coffeecode.net/2012/pgopen_fulltext/pgsql-fulltext-intro.html Full-text search - seek and ye shall find]<br />
<br />
=== Lightning Talks ===<br />
<br />
TBD!<br />
<br />
== Wednesday September 19 ==<br />
<br />
* [http://pgexperts.com/document.html?id=54 Super Jumbo Deluxe], plus [http://pgexperts.com/presentations.html more presentations here]<br />
* [[Media:OO_approach.pdf|An object oriented approach to data driven software development]]<br />
* TransLattice Elastic Database Architecture Deep Dive<br />
<br />
* [http://www.pateldenish.com/2012/04/deploying-maximum-ha-architecture-with-postgresql.html Deploying maximum HA architecture with Postgres]<br />
* Scaling Postgres with some help from Redis<br />
* Retail DDL<br />
<br />
* Query Logging and Workload Analysis<br />
* A Shared-nothing cluster system: Postgres-XC<br />
* DVDStore Benchmark and PostgreSQL<br />
<br />
* Performance Improvements in PostgreSQL 9.2<br />
* A Batch of Commit Batching<br />
* [http://momjian.us/main/presentations/features.html#cte Programming the SQL Way with Common Table Expressions]<br />
<br />
* Postgres is the new default – how we transitioned our platform at Engine Yard and why you should too<br />
* Leveraging PLV8 in Javascript-heavy Web Applications<br />
* PG Extractor - A smarter pg_dump</div>Denish