https://wiki.postgresql.org/api.php?action=feedcontributions&user=Klpaskett&feedformat=atomPostgreSQL wiki - User contributions [en]2024-03-29T09:23:13ZUser contributionsMediaWiki 1.35.13https://wiki.postgresql.org/index.php?title=Postgres_Open_2013&diff=20799Postgres Open 20132013-09-19T03:09:49Z<p>Klpaskett: /* Wednesday September 18 */</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 />
* [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]<br />
* [http://momjian.us/main/writings/pgsql/inside_shmem.pdf 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 />
* [https://wiki.postgresql.org/wiki/File:PostgresOnZFS-PGO.pdf 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 />
* [http://www.keithf4.com/wp-content/uploads/2013/09/pg_open2013_when_pg_cant_you_can.pdf When PostgreSQL Can't, You Can]<br />
* [http://bit.ly/1eddml6 Writing portable postgreSQL-backed network applications for the open cloud]</div>Klpasketthttps://wiki.postgresql.org/index.php?title=File:PostgresOnZFS-PGO.pdf&diff=20797File:PostgresOnZFS-PGO.pdf2013-09-19T03:06:48Z<p>Klpaskett: </p>
<hr />
<div>== Licensing ==<br />
{{The PostgreSQL Licence}}</div>Klpasketthttps://wiki.postgresql.org/index.php?title=Postgres_Open_2012&diff=18371Postgres Open 20122012-10-12T05:07:30Z<p>Klpaskett: /* Monday September 17 */</p>
<hr />
<div>Slides for talks will be linked here!<br />
<br />
== Monday September 17 ==<br />
<br />
* [https://wiki.postgresql.org/wiki/File:Pg_security_20120917.odp PostgreSQL AuthN / AuthZ]<br />
* [https://wiki.postgresql.org/images/8/86/PostgreSQL_on_ZFS.pdf PostgreSQL on ZFS]<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 />
* [[Media:PGXC_Scalability_PGOpen2012.pdf|Scaling out by distributing and replicating data in Postgres-XC]]<br />
* PostgreSQL When It's Not Your Job<br />
<br />
* [http://tapoueh.org/images/fotolog.pdf Large Scale MySQL Migration to PostgreSQL]<br />
* Choosing a logical replication system: Slony vs Bucardo<br />
* Temporal Database Demo<br />
<br />
* [http://www.setspace.com/~jmscott/pgopen-2012-ams-talk.pdf 12 Calm Years of PostgreSQL in Critical Messaging]<br />
* [https://speakerdeck.com/u/jacobian/p/the-first-postsql-database 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 />
* [http://plv8-pgopen.herokuapp.com 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 />
* [[Media:Logging_pgopen_withnotes.pdf|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 />
[http://keithf4.com/sites/keithf4.com/files/pgjobmon_pgopen2012.pdf I wonder if my function works? (pg_jobmon)]<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 />
* [https://docs.google.com/presentation/pub?id=1xKixOq3NP0OjQyXpL46woSDel-LzXxtbjDVOJX-holw&start=false&loop=false 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 />
* [http://jkshah.blogspot.com/2012/09/pgopen-2012-dvdstore-benchmark-and.html DVDStore Benchmark and PostgreSQL]<br />
<br />
* Performance Improvements in PostgreSQL 9.2<br />
* [[Media:CommitBatching.pdf|A Batch of Commit Batching]]<br />
* [http://momjian.us/main/presentations/features.html#cte Programming the SQL Way with Common Table Expressions]<br />
<br />
* [https://speakerdeck.com/u/randommood/p/postgres-is-the-new-default 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 />
* [http://keithf4.com/sites/keithf4.com/files/pgextractor_pgopen2012.pdf PG Extractor - A smarter pg_dump]</div>Klpasketthttps://wiki.postgresql.org/index.php?title=Postgres_Open_2012&diff=18370Postgres Open 20122012-10-12T05:06:18Z<p>Klpaskett: /* Monday September 17 */</p>
<hr />
<div>Slides for talks will be linked here!<br />
<br />
== Monday September 17 ==<br />
<br />
* [https://wiki.postgresql.org/wiki/File:Pg_security_20120917.odp PostgreSQL AuthN / AuthZ]<br />
* [https://wiki.postgresql.org/images/8/86/PostgreSQL_on_ZFS.pdf]<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 />
* [[Media:PGXC_Scalability_PGOpen2012.pdf|Scaling out by distributing and replicating data in Postgres-XC]]<br />
* PostgreSQL When It's Not Your Job<br />
<br />
* [http://tapoueh.org/images/fotolog.pdf Large Scale MySQL Migration to PostgreSQL]<br />
* Choosing a logical replication system: Slony vs Bucardo<br />
* Temporal Database Demo<br />
<br />
* [http://www.setspace.com/~jmscott/pgopen-2012-ams-talk.pdf 12 Calm Years of PostgreSQL in Critical Messaging]<br />
* [https://speakerdeck.com/u/jacobian/p/the-first-postsql-database 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 />
* [http://plv8-pgopen.herokuapp.com 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 />
* [[Media:Logging_pgopen_withnotes.pdf|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 />
[http://keithf4.com/sites/keithf4.com/files/pgjobmon_pgopen2012.pdf I wonder if my function works? (pg_jobmon)]<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 />
* [https://docs.google.com/presentation/pub?id=1xKixOq3NP0OjQyXpL46woSDel-LzXxtbjDVOJX-holw&start=false&loop=false 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 />
* [http://jkshah.blogspot.com/2012/09/pgopen-2012-dvdstore-benchmark-and.html DVDStore Benchmark and PostgreSQL]<br />
<br />
* Performance Improvements in PostgreSQL 9.2<br />
* [[Media:CommitBatching.pdf|A Batch of Commit Batching]]<br />
* [http://momjian.us/main/presentations/features.html#cte Programming the SQL Way with Common Table Expressions]<br />
<br />
* [https://speakerdeck.com/u/randommood/p/postgres-is-the-new-default 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 />
* [http://keithf4.com/sites/keithf4.com/files/pgextractor_pgopen2012.pdf PG Extractor - A smarter pg_dump]</div>Klpasketthttps://wiki.postgresql.org/index.php?title=File:PostgreSQL_on_ZFS.pdf&diff=18369File:PostgreSQL on ZFS.pdf2012-10-12T05:01:49Z<p>Klpaskett: Slides from PostgreSQL on ZFS tutorial. Slides include a link to an updated Virtual Machine which includes scripts and exercises from the tutorial.</p>
<hr />
<div>Slides from PostgreSQL on ZFS tutorial. Slides include a link to an updated Virtual Machine which includes scripts and exercises from the tutorial.</div>Klpaskett