Joy of Index*
Every SQL database needs indexes, but which indexes? Learn how to index, when to index, why to index, and how to feel after you've indexed.
Every SQL database needs indexes, but which indexes? Learn how to index, when to index, why to index, and how to feel after you’ve indexed.
In 40 minutes, you will learn a set of basic principles which will help you decide how to index your databases which apply to almost any SQL database. You will also discover the PostgreSQL tools which allow you to check if you’ve indexed correctly on that DBMS.
Josh Berkus is best known as a Core Team member of the world-spanning PostgreSQL project. He is CEO of PostgreSQL Experts, Inc. and in his 12 years as a database consultant he has worked with CouchDB, MySQL, Oracle, and MSSQL Server as well as Postgres, and is heavily involved in many OSS communities, including BIRT, OSCON, OSfA, Noisebridge and more. He’s also a potter and a mean cook.
- Title: Give a Great Tech Talk
- Track: Culture
- Room: St. Johns
- Time: 10:00 – 11:45am
Why do so many technical presentations suck? Make sure that yours
doesn’t. Josh Berkus and Ian Dees will show you how to share your
ideas with your audience by speaking effectively and (when the
situation warrants it) showing your code.
- Speakers: <a href="/users/30">Josh Berkus</a>, <a href="/users/103">Ian Dees</a>
- Title: Relational vs. Non-Relational
- Track: Cooking
- Room: Morrison
- Time: 2:30 – 3:15pm
What kind of database do you need?
Thanks to new database projects like CouchDB, TokyoCabinet, Solr and others, there are more non-relational database options available than ever for developers. Yet good information on how to choose what kind of database you need is still scarce. We’ll cure that in this talk.
- Speakers: <a href="/users/30">Josh Berkus</a>
- Title: Introduction to PostgreSQL
- Track: Cooking
- Room: Broadway
- Time: 1:30 – 2:15pm
Interested in using PostgreSQL for you next project, or migrating to it? This tutorial will go over the basics of PostgreSQL administration and database application design.
- Speakers: <a href="/users/30">Josh Berkus</a>, <a href="/users/584">Christophe Pettus</a>