There were 20 attendees, including Melanie Plageman of Pivotal presenting/coordinating “Postgres Patch Review,” and Postgresql.org -Hacker Jeff Davis as hands on help. This was the first workshop of its kind for Silicon Valley Postgres and with the feedback received, we are planning to plan similar events at least twice a year to provide an opportunity that is currently not available elsewhere. (Sneak peek: there may be one at PostgresConf Silicon Valley on October 15th and 16th, which is right around the corner!)

Eight patches were reviewed, with three including specific feedback to the patch authors:

• Bhushan Uparkar on Index Skip Scan
• Mathias Brossard on psql command to show size of partition table
• Kaiting Chen on fixing quadratic performance of regexp match/split functions

We’re excited to be a part of this path of Postgres contributor building. Hopefully it will be a model for other meetups and community partners to follow in continuing to contribute to the Most Advanced Open Source Database ecosystem.

Silicon Valley Postgres is the fastest growing Postgres user group within North America. It was initiated just 12 months ago and will reach 700 members likely before Monday. The group exists to help all facets of Postgres users and the Postgres ecosystem, including, but not limited to, PostgreSQL, Greenplum, Aurora Postgres, AgensGraph, Yugabyte, ZomboDB, TimescaleDB.

After National 2017, the PGConf US team decided to take a long hard road to bring the best in educational content and advocacy to the entire Postgres ecosystem. Today, we welcome 2ndQuadrant as a Platinum sponsor and thank them for helping us with our year over year projects.

Other PGConf US news:

Attendees of PgConf.US , if you haven't gotten your hotel room booked, now is the time! Our block ends on March 6th. Point your browser over here and book that room. While you wait for your email confirmation from the Westin, you can take some time to review the following talk from PgConf US 2015, ToroDB: a new, open-source, document-oriented, JSON database, built on Postgres.

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.    Sponsors Sponsorship opportunities for the conference are still available. If your business PostgreSQL based products or services or if you are looking to recruit a PostgreSQL expert at our job fair, this is the place to be. Don’t miss your chance to be part of this dynamic and growing ecosystem. Download the sponsorship prospectus at: https://postgresconf.org/conferences/2018/sponsorships Our current premium sponsors are: Diamond: Amazon Web Services, Pivotal Platinum: Compose, OpenSCG, 2ndQuadrant, Microsoft Gold: Cybertec, JetBrains, Citus Data, EnterpriseDB For more information, please visit https://postgresconf.org/conferences/2018 We look forward to seeing you in April!

2ndQuadrant Sponsor Highlight Blog for PostgresConf 2019

 As part of the countdown to PostgresConf US 2019, learn more about about featured Platinum Sponsor 2ndQuadrant, including their commitment to partnering with and contributing to the Postgres community.

 

Tell us about the recent uptick in Oracle to Postgres migrations.

Licensing costs of Oracle is a significant factor for businesses looking to migrate towards PostgreSQL. Not only is PostgreSQL a more cost effective solution, but it provides enterprise-level capabilities and customization options. The increasing demand for migration services from Oracle to PostgreSQL can also be attributed to the availability of PostgreSQL in the cloud.

 

Where do you see the Postgres market going?

PostgreSQL has been gaining traction with every release; interest and usage by large enterprises worldwide is growing exponentially due to the robust capabilities it provides. 2ndQuadrant intends to continue their active contributions in development and supports the overall growth of PostgreSQL.

 

 Do you have any big wins this year?

2Q PGConf 2018 had a successful second year bringing together PostgreSQL developers and users. Both speakers and attendees enjoyed the combination of technical and use case topics as well as the diverse range of networking opportunities. 

Sri Rangarajan, Lead Software Engineer at Enova International, commented saying he appreciates 2ndQuadrant’s hard work in “promoting and fostering a savvy, healthy and helpful community to welcome newcomers just like [it] did for [him] 5 years ago!”

For the second year in a row, PostgreSQL has been named DBMS of the Year by DB-Engines. This shows that developers and users alike are acknowledging the robust and versatile capabilities that it has to offer.

 

What is the number one benefit you see within Postgres that everyone should be aware of?

PostgreSQL's advanced features cater to a broad range of use cases all within the same DBMS. Rather than going for edge case solutions, developers are relying on the absolute reliability of the hyperconverged database to simplify their production deployments.

 

What is the best thing about working with the Postgres community?

The Postgres community is one of the easiest global communities to work with. There is an open mindset all around and a common goal of growing the Postgres ecosystem as a whole. 

 

Tell us why you believe people should attend PostgresConf 2019 in March.

Conferences are a great way for people in the PostgreSQL community to come together and share knowledge and ideas, which is the true spirit of open source. It is very exciting to see into the future developments of the project from the people who contribute so much to its growth.

It is a great way for members of the community to come together in person to share knowledge in different areas of the technology, describe practical use cases, and give sneak previews into cutting edge technologies for future versions of PostgreSQL.

 

About 2ndQuadrant:

2ndQuadrant provides PostgreSQL Solutions for the Enterprise - reliably deploying them on the platform of your choice and providing 24/7 Production Support. Our solutions address all aspects of your database ecosystem, ensuring high availability, disaster recovery, backup & failover management, and much more. 

Moreover, we provide tools to make your deployment process simple and reliable. With over 100 years of combined code contributions to the PostgreSQL project, our engineers ensure that your PostgreSQL solutions are fully supported in your production environment.

Visit the 2ndQuadrant team in the Exhibit Hall in the Metropolitan Ballroom on Wednesday, March 20, and Thursday, March 21.  

Check out the full schedule for PostgresConf US 2019, and buy your tickets soon!

Come as you are

The theme of Postgres Conference for 2020 is: Come as you are. We want everyone to feel welcome. You are welcome for your love of People, Postgres, Data and a desire to ascend beyond the box. It isn’t about your race, gender, sexuality, political affiliation, or love of blueberry flavored popcorn. It is 100% about you, the creativity and excellence that only you can bring to our community.

Postgres Conference 2020 CFP now open

We are actively seeking content for the largest Postgres Conference in the world, set to be held from March 23rd to 27th, 2020  at the Marriott Marquis, Time Square! Please submit your content here.

Postgres Conference Silicon Valley 2019

Postgres Conference Silicon Valley doubled its attendance, making it the largest Postgres  Conference on the West coast ever! We are very pleased to be able to bring so many community members together for education, fun, and ecosystem support!

 

Training

• Postgres Conference is now offering live digital training throughout the year. Continuing on our mission of creating exceptional Postgres people, you can now not only register for pre-defined training but request specific training and we will connect you with a class! The current training options are:
• PostgreSQL Performance and Maintenance
• Finding and Fixing slow queries
• Postgres + Kubernetes: yes it really is a match made in heaven
• PostgreSQL Replication deployment and best practices
• PgPool-II Performance and best practices

 

Register here: https://postgresconf.org/conferences/Postgres-Digital-Training-Series

 

Digital Events

We have free digital events coming up including topics such as Kubernetes, DistributedSQL, Backups, Postgis and many more. Coming up: 

• Yugabyte Digital Webinar Series.
• Heimdall Data is providing a Webinar on October 22nd on Enterprise Authentication and Connections pooling

Join the PostgreSQL community in Philadelphia on July 13th and 14th 2017 for two days of fantastic PostgreSQL content. July 13th will contain trainings and July 14th will be breakout sessions. The call for papers and sponsors is also open! When submitting papers to PGConf US events, please review the presentation guidelines.



PGConf US Local events are designed to bring comprehensive educational content and networking opportunities to the "local" PostgreSQL community where the event is being held. They are perfect opportunities to show support for PostgreSQL, find leads and build relationships with other professionals and companies using and support PostgreSQL.










d at Huntsman Hall at The Wharton School

What is the future of Postgres?

When you observe the ecosystem you can’t help but ask yourself where the community and software is going next. It is without question that the future of data will reside in something Postgres. It may be PostgreSQL, Cockroach, Yugabyte, Aurora, Azure, or workload specific Postgres such as Greenplum. Based on the sheer number of successful software adventures that are based on Postgres, there is no doubt in our minds that it is the future. 

This is why the inclusivity of People, Postgres, Data is vital to the continued success of the community. It is also why we invite all of Postgres to Come As You Are from March 23rd - 27th, 2020 at the Marriott Marquis in Manhattan! 

Isn’t Postgres, PostgreSQL?

Yes, and no. It is true that the term Postgres is sometimes used as a short version of PostgreSQL which allows easier pronunciation of the project and software name. It is also true that PostgreSQL contains a great deal of Postgres code but it is not technically Postgres. In fact, Postgres predates PostgreSQL by quite a few years and had an interim fork called Postgres95 before the PostgreSQL project was founded. That is why we use Postgres as an inclusive term for all software Postgres including many that some would consider forks. Fun fact:  Did you know that Informix is based on Illustra, a commercial Postgres fork from 1997?

Call for Papers

We are actively seeking people to deliver exceptional educational opportunities at Postgres Conference 2020. Postgres Conference is the perfect opportunity for students, hobbyists, and professionals to exhibit their knowledge in solving problems that are People, Postgres, or Data related. Submit your proposal today.

Instructor lead Digital Training

We have the following training opportunities in November and December:

• November 12th: PostgreSQL Performance and Maintenance
• November 14th: Finding and Fixing Slow Queries in PostgreSQL
• November 21st: PostgreSQL and Kubernetes
• December 10th: PostgreSQL Replication deployment and best practices
• December 12th: PGPool-II: Performance and best practices

Register here.

Webinars

We have the following webinars in November:

• Nov 13: Designing a Change Data Capture and Two Data Center Architecture for a Distributed SQL Database
• Nov 14: Yugabyte DB 2.0 Jepsen Test Results and Distributed Transactions Algorithms in Google Spanner, YugabyteDB and CockroachDB
• Nov 20: Zero Down-Time Oracle to Cloud-Native PostgreSQL Migrations

Find more information here.

Interesting projects

• http://postgrest.org/en/v6.0/ PostgREST is a standalone web server that turns your PostgreSQL database directly into a RESTful API. The structural constraints and permissions in the database determine the API endpoints and operations.
• https://www.haproxy.org/ HAProxy is a free, very fast and reliable solution offering high availability, load balancing, and proxying for TCP and HTTP-based applications. It is particularly suited for very high traffic web sites and powers quite a number of the world's most visited ones. Over the years it has become the de-facto standard opensource load balancer, is now shipped with most mainstream Linux distributions, and is often deployed by default in cloud platforms. Related content.

 

• Friday, November 3, 2017: Half-day Trainings with Postgres experts
• Saturday, November 4, 2017: Breakout Sessions (lunch and coffee break provided)