{"id":3262,"date":"2011-07-23T17:21:39","date_gmt":"2011-07-24T01:21:39","guid":{"rendered":"http:\/\/www.chesnok.com\/daily\/?p=3262"},"modified":"2013-04-26T10:00:28","modified_gmt":"2013-04-26T18:00:28","slug":"oscon-postgres-represent-and-my-links-for-harder-better-faster-stronger-talk","status":"publish","type":"post","link":"https:\/\/www.chesnok.com\/daily\/2011\/07\/23\/oscon-postgres-represent-and-my-links-for-harder-better-faster-stronger-talk\/","title":{"rendered":"OSCON: Postgres represent! And my links for Harder, Better, Faster, Stronger talk"},"content":{"rendered":"<p>I&#8217;m giving a couple talks at OSCON this year. The first is on Tuesday, 10:40am room C123: <a href=\"http:\/\/www.oscon.com\/oscon2011\/public\/schedule\/detail\/19275\">Harder, Better, Faster, Stronger: Postgres 9.1<\/a>.  The other is <a href=\"http:\/\/www.oscon.com\/oscon2011\/public\/schedule\/detail\/18777\">Mistakes were Made<\/a>, Wednesday at 1:40pm in room D136.<\/p>\n<p>My colleague Robert Treat is giving a <a href=\"http:\/\/www.oscon.com\/oscon2011\/public\/schedule\/detail\/19206\">Pro PostgreSQL<\/a> workshop Wednesday at 1:40pm too, room 204. He&#8217;s also giving a <a href=\"http:\/\/www.oscon.com\/oscon2011\/public\/schedule\/detail\/19196\">Scalability Patterns<\/a> talk at 4:20pm Tuesday. I&#8217;m sure his talks will be awesome. \ud83d\ude42<\/p>\n<p>And here are the <a href=\"http:\/\/www.oscon.com\/oscon2011\/public\/schedule\/tag\/postgresql\">rest of the talks tagged with PostgreSQL<\/a>.<\/p>\n<p>Also remember &#8212; there&#8217;s a <a href=\"http:\/\/calagator.org\/events\/1250460814\">PgDay tomorrow<\/a> at the Oregon Convention Center!<\/p>\n<p>I&#8217;m pushing my examples for my 9.1 talk <a href=\"https:\/\/github.com\/selenamarie\/pg91demo\">into a github repo<\/a>.  It should be populated with whatever I decide to use for the talk by Monday evening.<\/p>\n<p>Building 9.1 for me on Mac OS X (leopard!) involved the following:<\/p>\n<p><code><br \/>\ngit tag -l | grep REL9_1<br \/>\ngit checkout REL9_1_BETA2<br \/>\n.\/configure --with-perl --with-python --prefix=\/opt\/pg91beta2 --with-readline<br \/>\nmake<br \/>\nmake install<br \/>\n<\/code><\/p>\n<p>Normal caveats apply &#8211; you need X Code of a reasonably recent version, and a bunch of support libraries to make this happen. I haven&#8217;t rebuilt from scratch on OS X in a long time, but now I realize that maybe I aught to go through the pain and document this again.<\/p>\n<p>But I digress!<\/p>\n<p>I have a long list of resources for this talk and wanted to share. Probably in the slides for the talk, I&#8217;ll provide shortlinks so that people can pull them up and read instead of listening to me \ud83d\ude00<\/p>\n<p>Here&#8217;s my links:<\/p>\n<ul>\n<li><a href=\"http:\/\/developer.postgresql.org\/\">Latest build of documentation for 9.1<\/a><\/li>\n<li><a href=\"http:\/\/www.pgcon.org\/2010\/schedule\/attachments\/149_PGCon2010-Built-in-Replication.pdf\">Heikki&#8217;s slides about replication<\/a>  <\/li>\n<li><a href=\"http:\/\/www.postgresql.org\/docs\/9.1\/static\/app-pgbasebackup.html\">pg_basebackup<\/a><\/li>\n<li><a href=\"http:\/\/developer.postgresql.org\/pgdocs\/postgres\/queries-with.html#QUERIES-WITH-MODIFYING\" title=\"Common Table Expressions\">Common Table Expressions<\/a><\/li>\n<li><a href=\"http:\/\/www.depesz.com\/index.php\/2011\/03\/16\/waiting-for-9-1-writable-cte\/\" title=\"Writeable CTE examples\">Writeable CTE Examples<\/a><\/li>\n<li><a href=\"http:\/\/xzilla.net\/blog\/2011\/Mar\/Upserting-via-Writeable-CTE.html\" title=\"Upserting with Writeable CTEs\">Upserting with Writeable CTEs<\/a><\/li>\n<li><a href=\"http:\/\/www.depesz.com\/index.php\/2011\/03\/04\/waiting-for-9-1-per-column-collation-support\/\" title=\"Per column collation support examples\">Per column collation support examples<\/a><\/li>\n<li><a href=\"http:\/\/facility9.com\/2011\/03\/postgresql-extensions\/\" title=\"Review of Postgres Extensions effects and usage for end users\">Review of Postgres Extensions effects and usage for end users<\/a><\/li>\n<li><a href=\"http:\/\/wiki.postgresql.org\/images\/0\/00\/PGDay2010-Extensions.pdf\" title=\"Dimitri's talk from last year about his work on Extensions\">Dimitri&#8217;s talk from last year about his work on Extensions<\/a><\/li>\n<li><a href=\"http:\/\/wiki.postgresql.org\/wiki\/PDXPUGDay2011#Building_and_Distributing_PostgreSQL_Extensions_Without_Learning_C_.28David_E._Wheeler.29\" title=\"David Wheeler's talk (tomorrow!) on building \nextensions\">David Wheeler&#8217;s talk (tomorrow!) on building extensions<\/a><\/li>\n<li><a href=\"http:\/\/wiki.postgresql.org\/wiki\/What's_new_in_PostgreSQL_9.1#K-Nearest-Neighbor_Indexing\">User-level overview of KNN Indexing<\/a> <\/li>\n<li><a href=\"http:\/\/www.sai.msu.su\/~megera\/postgres\/talks\/pgday-2010.pdf\" title=\"Developer overview of KNN Indexes\">Developer overview of KNN Indexes<\/a><\/li>\n<li><a href=\"http:\/\/www.depesz.com\/index.php\/2011\/01\/03\/waiting-for-9-1-unlogged-tables\/\" title=\"Unlogged tables overview with example performance test from depesz\">Unlogged tables overview with example performance test from depesz<\/a><\/li>\n<li><a href=\"http:\/\/rhaas.blogspot.com\/2010\/05\/global-temporary-and-unlogged-tables.html\" title=\"Robert Haas' analysis of features and differences between temporary tables and ulogged tables\">Robert Haas&#8217; analysis of features and differences between temporary tables and ulogged tables<\/a><\/li>\n<li><a href=\"http:\/\/wiki.postgresql.org\/wiki\/SSI\" title=\"SSI wiki page\">SSI wiki page<\/a><\/li>\n<li><a href=\"http:\/\/www.chesnok.com\/daily\/2011\/03\/24\/raw-notes-from-kevin-grittners-talk-on-ssi\/\" title=\"My notes from Kevin Grittner's talk on SSI\">My notes from Kevin Grittner&#8217;s talk on SSI<\/a><\/li>\n<li><a href=\"http:\/\/developer.postgresql.org\/pgdocs\/postgres\/warm-standby.html#SYNCHRONOUS-REPLICATION \" title=\"Postgres 9.1 docs on synchronous replication\">Postgres 9.1 docs on synchronous replication<\/a><\/li>\n<li><a href=\"http:\/\/wiki.postgresql.org\/wiki\/What%27s_new_in_PostgreSQL_9.1#Synchronous_replication_and_other_replication_features\" title=\"Wiki page for synchronous replication\">Wiki page for synchronous replication<\/a><\/li>\n<li><a href=\"http:\/\/wiki.postgresql.org\/wiki\/Synchronous_replication \" title=\"Developer wiki page about synchronous replication implementation\">Developer wiki page about synchronous replication implementation<\/a><\/li>\n<li><a href=\"http:\/\/www.pgexperts.com\/document.html?id=50\" title=\"Josh Berkus' Magical Mystery Tour of 9.1 features\">Josh Berkus&#8217; Magical Mystery Tour of 9.1 features<\/a> <\/li>\n<\/ul>\n<p>And if you&#8217;re wondering about the title, I took it from an great Daft Punk song that fans have created some epic videos of:<\/p>\n<p><iframe loading=\"lazy\" title=\"Daft Hands - Harder, Better, Faster, Stronger\" width=\"500\" height=\"375\" src=\"https:\/\/www.youtube.com\/embed\/K2cYWfq--Nw?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;m giving a couple talks at OSCON this year. The first is on Tuesday, 10:40am room C123: Harder, Better, Faster, Stronger: Postgres 9.1. The other is Mistakes were Made, Wednesday at 1:40pm in room D136. My colleague Robert Treat is &hellip; <a href=\"https:\/\/www.chesnok.com\/daily\/2011\/07\/23\/oscon-postgres-represent-and-my-links-for-harder-better-faster-stronger-talk\/\">Continue reading &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[97,9,84,487],"tags":[471,622,647,470,624,460,148],"class_list":["post-3262","post","type-post","status-publish","format-standard","hentry","category-postgres","category-postgresql","category-presentation","category-speaking","tag-harder-better-faster-stronger","tag-oscon","tag-postgres","tag-postgres-9-1","tag-postgresql","tag-resources","tag-talk"],"_links":{"self":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/3262","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/comments?post=3262"}],"version-history":[{"count":10,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/3262\/revisions"}],"predecessor-version":[{"id":4782,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/3262\/revisions\/4782"}],"wp:attachment":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/media?parent=3262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/categories?post=3262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/tags?post=3262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}