I’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 giving a Pro PostgreSQL workshop Wednesday at 1:40pm too, room 204. He’s also giving a Scalability Patterns talk at 4:20pm Tuesday. I’m sure his talks will be awesome. 🙂

And here are the rest of the talks tagged with PostgreSQL.

Also remember — there’s a PgDay tomorrow at the Oregon Convention Center!

I’m pushing my examples for my 9.1 talk into a github repo. It should be populated with whatever I decide to use for the talk by Monday evening.

Building 9.1 for me on Mac OS X (leopard!) involved the following:


git tag -l | grep REL9_1
git checkout REL9_1_BETA2
./configure --with-perl --with-python --prefix=/opt/pg91beta2 --with-readline
make
make install


Normal caveats apply – you need X Code of a reasonably recent version, and a bunch of support libraries to make this happen. I haven’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.

But I digress!

I have a long list of resources for this talk and wanted to share. Probably in the slides for the talk, I’ll provide shortlinks so that people can pull them up and read instead of listening to me 😀

Here’s my links:

• Latest build of documentation for 9.1
• Heikki’s slides about replication
• pg_basebackup
• Common Table Expressions
• Writeable CTE Examples
• Upserting with Writeable CTEs
• Per column collation support examples
• Review of Postgres Extensions effects and usage for end users
• Dimitri’s talk from last year about his work on Extensions
• David Wheeler’s talk (tomorrow!) on building extensions
• User-level overview of KNN Indexing
• Developer overview of KNN Indexes
• Unlogged tables overview with example performance test from depesz
• Robert Haas’ analysis of features and differences between temporary tables and ulogged tables
• SSI wiki page
• My notes from Kevin Grittner’s talk on SSI
• Postgres 9.1 docs on synchronous replication
• Wiki page for synchronous replication
• Developer wiki page about synchronous replication implementation
• Josh Berkus’ Magical Mystery Tour of 9.1 features

And if you’re wondering about the title, I took it from an great Daft Punk song that fans have created some epic videos of: