PostgreSQL Indexes Explained

  • December 11, 2013 · 6:30 PM

Hard to believe that it's time for the final NYCPUG meetup of 2013.  We began the year with a whirlwind tour of PostgreSQL data types, so it's only appropriate to conclude the year with explaining all of the PostgreSQL indexes.

PostgreSQL comes built-in with a variety of indexes, some of which are further extensible to build powerful new indexing schemes. But what are all these index types? What are some of the special features of these indexes? What are the size & performance tradeoffs? How do I know which ones are appropriate for my application?

At NYCPUG we aim to answer all of these questions as Jonathan S. Katz will explore the whole family of PostgreSQL indexes: B-tree, expression, GiST (of all flavors), GIN and how they are used in theory and practice.

This month, NYCPUG will be hosted at Gilt at 2 Park Ave, 5th Floor.  Rangarajan Radhakrishnan, a senior software engineer at Gilt, will open up the evening with a brief presentation on "Docker and Postgres"

Please ensure that you RSVP with your first & last name, otherwise you will not be able to get building access.

Join or login to comment.

  • nbabu

    thanks for nice session guys , good luck

    December 12, 2013

  • Janet Y.

    Nice environment, interesting presentation. Thank you Jonathan!

    December 12, 2013

  • Jonathan S. K.

    Thank you everyone for attending last night! See below for links to the slides, and the examples:

    http://www.slideshare.net/jkatz05/explain-the-index-of-postgresql-indexes

    http://files.meetup.com/1288046/examples.zip

    1 · December 12, 2013

  • Scott D.

    Rich topic, and Jon handled it adeptly.

    December 12, 2013

  • Steve L.

    Hi guys I have a question. I am just starting to learn postgresql. Do you think someone who has no experience in PG will understand the lecture or should I study more before I join this class? Please let me know.

    December 5, 2013

    • Jonathan S. K.

      It's targeted as an introductory talk and each part builds on itself. Having some familiarity with SQL syntax will help, and having a cursory understanding of a few of the PostgreSQL data types helps too.

      December 5, 2013

    • Steve L.

      thanks i will be there

      December 5, 2013

  • Scott D.

    I'd like to talk a little bit about range types and indexes, particularly around temporal ranges. Anyone else looking at these for "bitemporal" data and associated witchcraft besides me?

    November 25, 2013

    • Scott D.

      Err, can I just give you the name in here? (Boris Serebrinskiy)

      November 25, 2013

    • Jonathan S. K.

      Yes, but I might forget to check prior to the meetup to get him on the list ;-) However he's already a member so I RSVP'd him

      November 26, 2013

  • Eugene P.

    will this one be recorded?

    November 26, 2013

    • Jonathan S. K.

      We are not planning to record it, but if Gilt records based on their policies then it will be.

      November 26, 2013

Our Sponsors

People in this
Meetup are also in:

Create your own Meetup Group

Get started Learn more
Rafaël

We just grab a coffee and speak French. Some people have been coming every week for months... it creates a kind of warmth to the group.

Rafaël, started French Conversation Group

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy