PostgresConf US 2018: Schedule almost granite!

With more than 200 events submitted and approximately 80 slots to be filled, this has been the most difficult schedule to arrange in the history of PostgresConf. By far, the majority of content received we wanted to include in the schedule. It is that level of community support that we work so hard to achieve and we are thankful to the community for supporting PostgresConf. There is no doubt that the number one hurdle the community must overcome is effective access to education on Postgres. The US 2018 event achieves this with two full days of training and three full days of breakout sessions, including the Regulated Industry Summit and Greenplum Summit.

For your enjoyment and education here is our almost granite schedule!

See something you like? Then it is time to buy those tickets!

This event would not be possible without the continued support from the community and our ecosystem partners:

Diamond: Amazon Web Services, Pivotal
Platinum: IBM, 2ndQuadrant, Microsoft, and OpenSCG
Our growing list of Sponsors/Partners

Joshua D. Drake February 22, 2018

PostgresConf US 2018: Early Bird Registration ends on January 31st

The month of January is just about over and we are coming up on the end of our Early Bird registration window for PostgresConf US 2018, which takes place in Jersey City, New Jersey from April 16th to April 20st at The Westin Jersey City Newport.

You have until tomorrow to purchase your tickets for $200 off for the largest PostgreSQL conference in the world. Early Bird tickets are on sale here through January 31.

We are excited to announce that we received over 170 proposals for PostgresConf US 2018, with an impressive range of high quality content and speakers. On April 16th and 17th, we are pleased to offer a choice of 15 different training sessions so you are sure to have the chance to dig deep into a topic that interests you. Some of our training classes are:

Mastering PostgreSQL Administration
Tutorial on Modern PostgreSQL High Availability
Deep Dive into PostgreSQL Authentication Methods
Digging into Advanced SQL
The postgresql.conf from A-Z: Includes Postgres Performance and Maintenance

For a complete list, check out the events page for all of our training classes.

Also during PostgresConf, you will also have an opportunity to meet our great sponsors, including:

Diamond: Amazon Web Services, Pivotal
Platinum: Compose, OpenSCG, 2ndQuadrant, Microsoft
Gold: Cybertec, JetBrains, Citus Data, EnterpriseDB, Linode, Timescale, Cockroach Labs

At the Westin Jersey City Newport, we have negotiated a discounted conference room rate of $260/night + applicable taxes for attendees. Be sure to book prior to March 26, 2018 - the conference rate is not guaranteed after this date. Rooms may be booked via our dedicated Westin booking page, or via telephone (888) 627-7148. If booking via telephone please mention "PostgresConf US 2018" to receive the group rate.

For more information, please visit the PostgresConf US 2018 website.

Stay tuned for our presentation and breakout sessions announcement. We look forward to seeing you in April!

P.S. Looking for a discount code? Check your local Postgres User Group mailing list.

Debra Cerda January 30, 2018 postgres

PostgresConf US 2018: CFP ends on January 22nd

That's right, folks; the time has come.

What time you ask?

The time to join the largest Postgres Conference in the world by submitting a talk or training to PostgresConf US 2018!

We want to set the world stage for what a Postgres and Data conference should look like with quality people, quality content, and lots of interesting things about data.

Your window is short; the CFP closes on Monday at midnight. That means no last minute, witching-hour submissions!

Submit now and AmplifyPostgres!

PostgresConf.Org would not be possible without our speakers, attendees and sponsors.

Diamond: Amazon Web Services, Pivotal

Platinum: Compose.IO, 2ndQuadrant, OpenSCG, Microsoft

Joshua D. Drake January 18, 2018

2017, the year PostgresConf and Postgres reached the masses

No year has been better for PostgreSQL or the Postgres Ecosystem than 2017. The continued adoption and growth of open source communities over the last 40 years shows a mature and strong ecosystem. It is true what they say, "Middle age is the best time of your life." Here are just a few of the great results of 2017:

Amazing work from PostgreSQL.Org with the release of v10 which brought much sought after technologies such as native table partitioning, integrated logical replication, and mature support for federated tables.
Pivotal announced multi-cloud support for their Open Source, BigData, MPP Postgres variant Greenplum.
Increased support and features from Cloud Industry heavy weights AWS, Compose.IO, and Microsoft. Microsoft released Azure Database for PostgreSQL, Compose increased their high availability options, and AWS announced the availability of Amazon Aurora with PostgreSQL compatibility.
Enterprise Consulting and Support continued to grow with support from PostgreSQL.Org Major Sponsors 2ndQuadrant and OpenSCG.

2017 was also the year we saw the launch of the International Postgres Conference, PostgresConf. The PostgresConf project is a globally aware, ecosystem centric conference focused on People, Postgres, Data. The project organized more events this year than any other Postgres Advocacy and Education project. In the United States there was PGConf US (now PostgresConf US), Austin Mini, Philadelphia, (2) NYC Minis, Seattle, and finally a full Austin event. The project also hosted PostgresConf South Africa and has several International events planned in 2018.

The PostgresConf International efforts wouldn't be possible without the fundamental support of the community and our ecosystem partners:

We have nothing but confidence in the continued growth of PostgreSQL and the Postgres related ecosystem through 2018. Thank you to the PostgreSQL.Org community, our ecosystem partners, and the global Postgres Ecosystem community; without you our efforts would not continue to succeed as a volunteer organized, non-profit Postgres conference. We are looking forward to a fantastic 2018, centered on People, Postgres, Data.

Joshua D. Drake January 08, 2018

Registration is open for PostgresConf US 2018

Welcome to a new and bigger year for Postgres in 2018!

As our events have grown and evolved, so has our branding. We started as a small pgDay event, grown to a larger pgConf and now we are happy to announce that we matured into a full week long event called PostgresConf.

PostgresConf US 2018 is focused on People, Postgres and Data. People are the driving force behind the Postgres Ecosystem from the hackers writing the code, to the advocates telling the world about Postgres and to the administrators and developers using Postgres day to day. They will all be represented at PostgresConf.

Tickets

We have excellent news for you all: registration is open for PostgresConf US 2018 and discounted Early Bird tickets are just $399 -- $200 off the regular $599 -- and available through January 31, 2018, at https://postgresconf.org/conferences/2018

Please note that the early bird registration admits one person to the main conference sessions on Wednesday April 18 - Friday April 20, 2018, the Regulated Industry Summit, the Greenplum Summit, the Community Summit, and all evening activities from Wednesday - Friday. This registration does NOT include any training sessions on Monday April 16 or Tuesday April 17. Tickets for the training sessions are available separately, at $199 for half-day training and $499 for a full day training.

Day passes will be available for single day admission Wednesday through Friday, for $299 -- why not register early and get all 3 days for just $100 more?!

About our Conference

The Postgres Ecosystem is more than just the exceptional PostgreSQL database. It encompasses tools, solution, and services that enterprises demand for their mission-critical applications. PostgresConf brings the whole ecosystem under a single roof so enterprises can learn about all of the possible ways Postgres can be used in their environments.

This year, we are back in Jersey City from April 16th to April 20th at The Westin Jersey City Newport. We also listened to our past attendees and expanded our training classes to 2 days so on April 16th and 17th, we are pleased to offer training sessions taught by professional trainers to bring additional depth to your learning experience. That will be followed by 3 days of great talks on April 18th - 20th. Additionally, we will host our 4th annual Regulated Industry Summit as well as the inaugural Greenplum Summit.

CFP

Want to present? Our CFP is open! Please visit https://postgresconf.org/conferences/2018 for Call for Papers information.

Where to Stay

For those planning to attend, don’t forget to book your room early for the best rates. The Westin Jersey City Newport is the best place to stay and enjoy all conference activities. Attendees will surely mingle at the Westin bar and hallways throughout the afternoon and long into the evening. We have reserved a block of rooms at the special conference rate of $260/night plus applicable taxes for attendees who make their reservations via this dedicated Westin booking page. The hotel block will fill up quickly. The special rates will be available until March 26 or until the group block is sold out.

Community Profile: LLoyd Albin of Fred Hutchinson Cancer Research Center

How do you use Postgres?

I work Fred Hutchinson Cancer Research Center and within Fred Hutch, I work for the largest group called SCHARP, Statistical Center for HIV/AIDS Research and Prevention. We use Postgres to monitor the AIDS drug trials real time to see if the trials are working or not. This means we collect the data from doctors and labs around the world, and analyzing the data. We also have servers where we receive data from other research institutes and share our randomized data, de-personalized, with other research institutes.

What community contributions have you provided?

In 2010 I started SeaPUG, Seattle Postgres Users Group, at the request of Josh Drake. I have at least have the presentations there every year. I have also discovered several PostgreSQL: bugs which have been fixed. Some of them affected every version of PostgreSQL. Bug numbers: 7553, 8173, 8257, 8291. I also found 8545, which has not been fixed but Core has acknowledge needs to be fixed but they are not sure where it should be fixed, pg_dump or pg_dumpall. I started the PostgreSQL track at LinuxFest Northwest in 2014 after my GIS presentation in 2013 was standing room only. This year I got a booth at the SeaGL, Seattle GNU Linux, conference with the idea of having a booth there next year along with also doing a PostgreSQL presentation next year at the conference.

You recently took a renewed interest in speaking at Postgres Conferences, why?

I have been giving presentations locally now for the last 7 years and so I am now ready to move on to the next step, doing presentations at the Local and National conferences around the United States.

What is the #1 barrier you see to Postgres adoption?

People not knowing about PostgreSQL, most people know about MYSQL, MSSQL and Oracle, but do not know about PostgreSQL. This is changing, some, with the Cloud providers now offering PostgreSQL, but I go to these conferences, LinuxFest Northwest and SeaGL, and people all the time are asking me, "What is Postgres and why should I use it over MYSQL, MSSQL or Oracle", because they have never heard of PostgreSQL.

What is something you feel the wider Postgres community could be better at?

We need to promote PostgreSQL so that new people starting personal projects and starting at companies, will think about PostgreSQL before other databases. This starts with getting the younger generation interested in PostgreSQL and that also means that we need to get the college professors willing to talk about PostgreSQL in their curriculums instead of ignoring PostgreSQL for all the other competing databases. Some of this means that at all the other conferences, we need to have a PostgreSQL presence, aka booth and presentations. We should also come up with a certification method for PostgreSQL DBA's, User's, Engineer's, etc so that prospective employers will have an idea of the prospective employees skill set.

Joshua D. Drake December 12, 2017

3 presentations, 1 PGConf: NYC Mini!

We are having yet another PGConf Mini in NYC. The event is scheduled for December 14th, 2017 and Work Bench is hosting:

The event is part of the PGConf Mini series and is free to attend. The PGConf Mini series works directly with user groups and external communities to organize events for the local community. The events are held as a larger meetup style event with networking opportunities and up to 4 presentations. The current agenda for the latest PGConf Mini: NYC is:

Agenda:

• 6:30 - 7:00: Jonathan Katz, (TBD), Postgresql Contributor and PGConf Chair Emeritus

Efficiently and Safely Propagate Data Changes Without Triggers!

Prior to PostgreSQL 9.4, the primary way to distribute data-driven changes across multiple tables was to use triggers. While triggers guarantee that these changes will be propagated, they can have a significant impact application performance, both technically and with development time (see: "debugging"). PostgreSQL 9.4 introduced logical decoding, which provides a way to stream all changes in a database to a consumer. Using a logical decoder, you can read all changes that are made in a table into your programming language of choice to perform many tasks: cache invalidation, data propagation, submitting changes to remote services, and more. Many PostgreSQL drivers, such as psycopg2 and JDBC support the logical replication protocol, which lets you easily stream your database changes to be manipulated using your favorite programming language. This talk will demonstrate how you can setup logical decoding for your application, look at architecture strategies for working with a logical decoder, and look at a case-study that shows how using logical decoding led to a big performance boost over a similar trigger-based system.

• 7:00 - 7:30: Kevin Jernigan, Senior Product Manager, Amazon

Technical Architecture of Postgres Aurora

Amazon Aurora is a cloud-optimized relational database that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. The recently announced PostgreSQL-compatibility, together with the original MySQL compatibility, are perfect for new application development and for migrations from overpriced, restrictive commercial databases. In this session, we’ll do a deep dive into the new architectural model and distributed systems techniques behind Amazon Aurora, discuss best practices and configurations, look at migration options and share customer experience from the field.

• 7:30 - 8:20: Joshua (JD) Drake POSTPONED due to flight cancellation)

The Power of Postgres Replication, Postgres Expert - Lead Consultant Command Prompt, Inc and Co-Chair PGConf!

With PostgreSQL v10 a new replication engine has come to town. Let's explore Postgres Logical Replication, how to use it, optimize it and let it best fit in with your organization. We will also discuss its interactions with external tools as well as Binary Replication and features such as Hot Standby.

You can RSVP at the NYC PostgreSQL Meetup and as always, @amplifypostgres !

Joshua D. Drake November 20, 2017

PGConf Local: Austin Program Announced and Tickets Available!

It is with great pleasure that we announce the preliminary program for PGConf Local: Austin!

We have received a plethora of positive feedback from the local Postgres and Data communities and we are proud to host a second PGConf event held in Austin in 2017.

Training Opportunity:

Postgres Performance and Maintenance by Joshua D. Drake

Breakout Sessions:

Event Sourcing with a Postgres Event Store by Scott Bellware
Using GIS in PostgreSQL by Lloyd Albin
Trees/Hierarchical Data in the SQL Database by Ryan Murphy
Amazon Aurora with PostgreSQL compatibility by James Finnerty
Deep Dive into the RDS PostgreSQL Universe by Grant McAlister
Open Source Communities as Biological Ecosystems by Debra Cerda
The Power of Postgres Replication by Joshua D. Drake
Multi-cloud deployment of PostgreSQL in minutes. by Stephen Holt

Join us! Tickets are available and will go fast!

PGConf Local: Austin is made possible by the wonderful team of volunteers including the Austin PostgreSQL User Group and our sponsors:

Platinum: Compose.IO, OpenSCG, 2ndQuadrant, and Microsoft

Joshua D. Drake November 09, 2017

Presenter Professionalism at Postgres Conferences

Andreas Scherbaum recently tweeted, “Speakers: it is NOT OK to even consider drinking alcohol during a talk! No matter how complicated your talk topic is.” The tweet has caused an interesting debate on Twitter and Facebook. It also caused me to run a poll via @amplifypostgres on the matter.

At the time of this writing almost 70% of the votes on the poll either don’t care or don’t think it is unprofessional for a presenter to drink alcohol while presenting.

One of the counter arguments to presenters consuming alcohol during presentations is that when you are presenting you are representing the conference. The conference wants you to be professional and create an environment that represents that during your talk. Fair enough, but why is it unprofessional?

This sequence of events has me wondering: what is professionalism in reference to presenting at Postgres Conferences? It is certainly not appropriate to be intoxicated while presenting at a professional conference, but that isn’t the question. The question is: why is it inappropriate for an adult to make a legal choice to take a nip or sip beer (or wine) during a presentation? Why is that more unprofessional than not wearing a tie or button up shirt, or wearing shorts or a kilt?

Professionalism is subjective.

Quoting the Oracle-Base blog:

“In my opinion, my obligations to the audience are:

I must care about the content.
I must deliver what I say I will deliver.
I must be honest with the audience about my level of experience in the subject.
I must be honest about my opinions on the subject.
I must be a genuine version of me, minus the swearing.”

I fail at “minus the swearing” but the rest are spot on and should be our focus.

If you do not want presenters to consume alcohol during their presentations, then add it to your Code of Conduct. If it’s not in your Code of Conduct, then let adults take responsibility for themselves and present the best content possible for our community, in whatever way necessary.

Rock on and @amplifypostgres!

Disclaimer: I am writing this opinion as a frequent presenter, not as the Co-Chair of the most electrifying Postgres Conference in the world.

Joshua D. Drake October 27, 2017

PGConf Local: Seattle, final program available

It is with great pleasure that we announce the final program for PGConf Local: Seattle. The schedule is still being hammered out but we have finalized the content that will be presented. Please join us in celebrating Postgres in Seattle!

The conference is the first Postgres event to be held in Seattle since 2009 and we have received a lot of positive feedback from the local Postgres and Data communities. Clearly Postgres has been missed in the Emerald City!

Training Options:

Postgres Performance and Maintenance by Joshua D. Drake
Scaling PostgreSQL Using Linux Containers in the Enterprise by Robert Bernier
Migrating from Oracle to PostgreSQL by Jim Mlodgenski

Breakout Sessions:

Track: Ops

Develop intelligent apps on the Azure platform using the Azure Database for PostgreSQL by Sunil Kamath
Tuning PostgreSQL for High Write Workloads by Grant McAlister
POSTGRESQL V10: AN AMPLIFIED VERSION OF POSTGRES by Joshua D. Drake
Enterprise Data Architecture with PostgreSQL by Kevin Kempter
All the dirt on Vacuum by Jim Nasby
Building a scalable time-series database on PostgreSQL by Matvey Arye

Track: Dev

Semantic Search Web System on PostgreSQL by QUAN-HA LE
Increase Application Performance with SQL Auto-Caching; No Code Changes by Roland Lee
Introduction to JavaScript Stored Procedures by Jim Mlodgenski
Under the hood: API integrations and more in an energy efficiency PostgreSQL + Django application by Jennifer Scheuerell
Using GIS in PostgreSQL by Lloyd Albin

Tracks: Big Data, Data Science and AWS/Cloud

With Great Power Comes Great Responsibility by Michael Sacks
Data Quality Expert Is Not Harvard's Sexiest Job...But... by Ben Rogojan
GRAKN.AI: the hyper-relational database for knowledge-oriented systems by Haikal Pribadi
Best Practices with Managed PostgreSQL in the Cloud by Jignesh Shah

PGConf Local: Seattle is made possible by the wonderful team of volunteers including the Seattle Postgres User Group and our sponsors: