PGCon certainly had some energizing talks and meetings this week. First, Jonathan Katz gave a tutorial about Postgres data types. Though I missed his talk, I just reviewed his slides and it is certainly a great tour of our powerful type system.
Second, Oleg Bartunov and Teodor Sigaev gave a great presentation about merging the very popular hstore and JSON date types into a new hierarchical hash data type, humorously code-named ‘jstore’. (Their work is funded by Engine Yard.) This generated a huge amount of discussion, which has continued to today’s unconference.
Third, Alvaro Hernandez Tortosa‘s talk The Billion Tables Project (slides) really stretched Postgres to a point where its high-table-count resilience and limitations became more visible. A significant amount of research was required to complete this project.PGCon Conference Report