PGCon, Ottawa 2009

PGCon is the annual 'big' PostgreSQL conference attended by users and developers from around the world. As well as two days of talks, there are tutorials and a developer meeting. See the bottom of this page for video links.

Tutorials / Talks

Time	Title	Presenter	Speaker Notes	Attendant Notes	Video
2009.05.19 Morning	PostgreSQL Access Controls	Stephen Frost	click
2009.05.19 Afternoon	Performance Whack-a-Mole II	Josh Berkus	click
2009.05.20 All Day	Developer Meeting	Core Team
2009.05.20 Morning	SkyTools: Queues (PgQ)	Marko Kreen, Martin Pihlak	click
2009.05.20 Afternoon	Writing a Procedural Language	Joshua Tolley	click
2009.05.21 Morning	Introduction & keynote	Dan Langille, Selena Deckelman, Magnus Hagander, Dave Page			click
2009.05.21 Morning	No More Waiting, A Guide To PostgreSQL 8.4	Rob Treat	click		click
2009.05.21 Morning	Some recent advances in full-text search	Teodor Sigaev, Oleg Bartunov	click
2009.05.21 Morning	Building PetaByte Warehouses with Unmodified PostgreSQL	Emmanuel Cecchet
2009.05.21 Noon	Saving the Amazon with PostGIS	Luis Fernando Bueno	click		click
2009.05.21 Noon	Visualizing Postgres	Michael Glaesemann	click
2009.05.21 Noon	Encrypted PostgreSQL	Magnus Hagander
2009.05.21 Afternoon	Database Hardware Benchmarking	Greg Smith	click	click
2009.05.21 Afternoon	Post Facto, version control for PostgreSQL	Robert Brewer
2009.05.21 Afternoon	Introduction to Recursive Queries	Gregory Stark
2009.05.21 Afternoon	pg_similarity, Functions and Operators for Executing Similarity Queries	Euler Taveira de Oliveira	click
2009.05.22 Morning	Reconciling and comparing databases	Norman Yamada	click		click
2009.05.22 Morning	How to Get Your PostgreSQL Patch Accepted	Tom Lane & Bruce Momjian	click		click
2009.05.22 Noon	VACUUM Strategy	Selena Deckelmann	click
2009.05.22 Noon	Predicting Postgres Performance	Jonah H. Harris			click
2009.05.22 Noon	Converting 100 databases to PostgreSQL	Kevin Grittner	click		click

PgCon 2009 Lightning talks

Videos for pgCon 2009

Some streaming videos are also available through the Free and Open Source Learning Center.

Videos for download are as follows:

tutorials

• security.mov (979.1MB)

• skytools.mov (878.8MB)

• performance.mov (1172.6MB)

• lolcode.mov (818.6MB)

sessions

0521

• pgcon2009-sessions-amazon.mov (396.8MB)

• pgcon2009-sessions-benchmarking.mov (390.7MB)

• pgcon2009-sessions-londiste3.mov (337.8MB)

• pgcon2009-sessions-no-more-waiting.mov (336.7MB)

• pgcon2009-sessions-openstreetmap.mov (346.8MB)

• pgcon2009-sessions-spatial.mov (346.8MB)

• pgcon2009-sessions-full-text.mov (300.5MB)

• pgcon2009-sessions-post-facto.mov (311.4MB)

• pgcon2009-sessions-power-psql.mov (199.7MB)

• pgcon2009-sessions-unit-test.mov (330.5MB)

• pgcon2009-sessions-visualizing.mov (320.2MB)

• pgcon2009-sessions-windowing.mov (319.6MB)

• pgcon2009-sessions-8-4beta.mov (217.5MB)

• pgcon2009-sessions-encrypted.mov (326.2MB)

• pgcon2009-sessions-lives-of-others.mov (307.4MB)

• pgcon2009-sessions-opening.mov (108.2MB)

• pgcon2009-sessions-petabyte.mov (291.7MB)

• pgcon2009-sessions-pg_similarity.mov (159.8MB)

• pgcon2009-sessions-upgrade.mov (286.5MB)

0522

• pgcon2009-sessions-golconde.mov (244.8MB)

• pgcon2009-sessions-predicting.mov (284.5MB)

• pgcon2009-sessions-reconciling.mov (236.5MB)

• pgcon2009-sessions-sql-med.mov (282.8MB)

• pgcon2009-sessions-fluiddb.mov (539.9MB)

• pgcon2009-sessions-temporal.mov (433.3MB)

• pgcon2009-sessions-vacuum.mov (252.3MB)

• pgcon2009-sessions-patch.mov (270.5MB)

• pgcon2009-sessions-100-databases.mov (315MB)

• pgcon2009-sessions-lightning.mov (259.7MB)

• pgcon2009-sessions-recursive.mov (301.3MB)

• pgcon2009-sessions-refactoring.mov (223MB)