Joy of Index

*

Excerpt

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.

Description

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.

Speaking experience

Speaker

  • Headshot

    Josh Berkus

    PostgreSQL Project

    Biography

    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.

    Sessions

      • Title: Give a Great Tech Talk
      • Track: Culture
      • Room: St. Johns
      • Time: 10:0011:45am
      • Excerpt:

        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:303:15pm
      • Excerpt:

        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:302:15pm
      • Excerpt:

        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>