addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgoogleimageimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

Web-Scale PostgreSQL: The New JSONB Data Type and the Relational World

  • Aug 11, 2014 · 6:30 PM

All data is relational and can be represented through relational algebra, right?  Perhaps, but there are other ways to represent data, and the PostgreSQL team continues to work on making it easier and more efficient to do so!

With the upcoming 9.4 release, PostgreSQL is introducing the "JSONB" data type which allows for fast, compressed, storage of JSON formatted data, and for quick retrieval.  And JSONB comes with all the benefits of PostgreSQL, like its data durability, MVCC, and of course, access to all the other data types and features in PostgreSQL.

How fast is JSONB?  How do we access data stored with this type?  What can it do with the rest of PostgreSQL?  What can't it do?  Join Jonathan S. Katz and Jim Mlodgenski as they take a look at the new features surrounding JSONB and how web-scale PostgreSQL is. 

Join or login to comment.

  • Ashok K.

    Awesome presentation. Thanks for sharing the slides.

    1 · August 12, 2014

  • Jonathan S. K.

    Hi Everyone - Thank you for attending last night. We have uploaded the slides here:

    http://www.slideshare.net/jkatz05/webscale-postgresql-jsonb

    Enjoy!

    2 · August 12, 2014

  • Peter M.

    Off-topic: Has anyone had any success finding a prebuilt TDS FDW that runs on (ugh) Windows?

    August 11, 2014

  • Perry

    Thanks!

    August 11, 2014

  • Aron P.

    yeah, can't wait.

    August 9, 2014

  • Thomas K.

    On the waitlist when will I know if I can join?

    August 6, 2014

    • Jonathan S. K.

      Hi Thomas - we will be sending an announcement soon kindly asking people to update their RSVPs if they cannot attend. We may be able to bump up the capacity a bit based on RSVPs => actual attendance numbers

      August 7, 2014

  • A former member
    A former member

    Please have more of these meetups. Cant' make it to this one.

    June 30, 2014

    • Jonathan S. K.

      Hi Brenda - We have one once a month, though the topics vary. I am going to announce the July one shortly but am in the process of looking for space :-)

      June 30, 2014

  • A former member
    A former member

    Consumer analytics

    June 24, 2014

Our Sponsors

People in this
Meetup are also in:

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