Debra Cerda Blog Posts

As part of the countdown to PostgresConf US 2018, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Abbas Butt is a Software Architect at EnterpriseDB, and he will present a half-day training "Deep dive into PostgreSQL Authentication Methods" on Monday, April 16, at 1 pm. Learn more about Abbas and his involvement in the Postgres community:

Why PostgreSQL?

My company's business revolves around PostgreSQL.

Tell us about your involvement with the greater Postgres community.

I have been involved with PostgreSQL for about 10 years. Over the years I have contributed by reporting bugs and developing various FDWs. I have also worked to make PostgreSQL an XA complaint database by using a modified version of pgBouncer. My next plans are to come up with small programming exercises with solutions to accompany this book http://www.interdb.jp/pg/ ("The Internals of PostgreSQL for database administrators and system developers"  by Hironobu Suzuki). This will give the readers hands on experience.

What new features of PostgreSQL 10 are you most excited about?

Declarative table partitioning & query parallelism

What features should be developed/improved and released in the next major upgrade?

Write Scalability and High Availability

Why should attendees come to your talk at PostgresConf US 2018? What would you like for them to take away from your session?

Attendees should come to have great time learning about PostgreSQL authentication methods. After attending the session the attendees will be better placed to decide which authentication scheme should they use and why.

What sessions are you most excited about attending at PostgresConf US 2018?

"Aurora PostgreSQL Tutorial and Extended Deep Dive" and "Know your meme: Develop a webapp using Google Cloud Kubernetes and Cloud SQL"

What is your favorite aspect of PostgresConf US?

Being able to listen and exchange point of views with other community members.

What advice would you have for a Computer Science graduate or entry level developer who are interested in learning and engaging with Postgres?

Read this book : "The Internals of PostgreSQL for database administrators and system developers"  by Hironobu Suzuki.

 

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

 

As part of the countdown to PostgresConf US 2018, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Elizabeth Zalman is the Co-founder & CEO of strongDM, the definitive data security product. Previously she was Co-Founder and CEO of the cross-device profile company Media Armor.

Liz will be presenting a breakout session "Do You Know Your Vendor Dependencies" on Wednesday, April 18, at 4 pm. Read what she has to say about Postgres and why to attend her session: 

Why PostgreSQL? What got you into it, and made you stick with it?

Featureful performance & proven reliability. Over the years I've found fewer and fewer reasons to consider alternatives beyond Postgres (two notable exceptions being redis-style KV and queues).

Tell us about your involvement with the greater Postgres community.

strongDM hears a lot about how its customers use PG and its derivatives (Greenplum, the latest on Aurora, etc.) and we love sharing tips when appropriate.

What new features of PostgreSQL 10 are you most excited about?

As a security product, we're always happy to see security-related upgrades: SASL/SCRAM authentication is a popular option in several of database systems, and is a significant upgrade over the previous salted hashes. We also rely heavily on partitioning, so all related enhancements are welcome.Finally: although we generally wouldn't choose to run parallel queries in a primarily OLTP system, the promise of running analytic queries on a replica (rather than ETL'ing into an analytic database) is very appealing.

What features should be developed/improved and released in the next major upgrade?

Dynamic optimization for queries on partitioned tables. Right now if you run select * from date_partitioned_table where event_timestamp between NOW() and NOW() - interval '7 days'; It scans every partition because the result of NOW() is not knowable ahead of time. But it could optimize that query when it was asked to execute it. Instead of creating a static query plan it could say, I know I'm going to have to compute a list of partitions. So, let's just remember that. Then right before the query runs, it could calculate the list and run the query as though it had been planned with a static date range, and thus only query the affected tables. 

 Why should attendees come to your talk at PostgresConf US 2018?

In this talk, I'll share practical examples of breaches I've personally experienced along with advice on how to hold your vendors accountable, and hopefully make the topic of security a little less intimidating in the process.

What sessions are you most excited about attending at PostgresConf US 2018?

I am looking forward to attending “Reducing the Surface Area of Risk in Data Security” by Tim Gorman and “General Data Protection Regulation (GDPR) with Azure Database for PostgreSQL” by Mark Bolz.

What is your favorite aspect of PostgresConf US?

Being able to network with and learn from a unique community! I’ve found practice to really be one of the best ways to learn about databases.

 What advice would you have for a Computer Science graduate or entry level developer who are interested in learning and engaging with Postgres? 

 I’ve found practice to really be one of the best ways to learn about databases. Get your hands dirty: try breaking things and then fixing them! 

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

 

 

 

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

As part of the countdown to PostgresConf US 2018, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Tom Limoncelli is the SRE Manager at StackOverflow.com and author of Time Management for System Administrators (O'Reilly). He is co-author of The Practice of System and Network Administration (3rd edition just released) and The Practice of Cloud System Administration.  

Tom will be presenting a half-day training on Monday, April 16 on "Personal Time Management: The Basics for Overloaded People." Read what he has to say about Postgres and why to attend his session:

Why PostgreSQL? What got you into it, and made you stick with it?

The startup I was at in 2003 needed a database. Since we did a lot of work with IP and network addresses, we picked PostgreSQL because it supports those as native types.

Tell us about your involvement with the greater Postgres community. 

I'm new to the greater Postgres community. I've been a system administrator since 1988 and often speak on related topics.

What features should be developed/improved and released in the next major upgrade?

Anything that makes replication and failovers easier and more reliable. 

Why should attendees come to your talk at PostgresConf US 2018? What would you like for them to take away from your session?

Time management: you will gain an additional day out of every week. Radical ideas: you'll learn how modern software ("distributed computing") is radically changing how we build systems and do operations. I'd like to give them hope for the future.

What is your favorite aspect of PostgresConf US?

That it's in my back yard!  I live 10 miles from here!

What advice would you have for a Computer Science graduate or entry level developer who are interested in learning and engaging with Postgres?

Give yourself projects. Try to break things and then see if you can repair them.  You'll learn more from recovering a failed system than anything else.

Bonus Question: You can invite any three living people from anywhere in the world to dinner. Who do you invite and why?

Obama (because I'd like to thank him), Steve Martin (because he has an amazing life story and is super smart), and Jennifer Lawrence (she also has an interesting life story).  I also think that these three people would get along well.

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

 

Speaker Spotlight: Tim Gorman

 

As part of the countdown to PostgresConf US 2018, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Tim Gorman is a technical consultant for Delphix who enable data virtualization and data masking to increase the agility of IT development and testing securely. Tim is co-author of six books about Oracle data warehousing and performance optimization, and has performed technical review for eight other published books. 

Tim will be presenting a breakout session on Wednesday, April 18 on "Reducing The Surface Area Of Risk In Data Security." Read what he has to say about Postgres and why to attend his session:

 

Why PostgreSQL? What got you into it, and made you stick with it?

30+ years in IT and databases, and PostgreSQL is the obvious heir apparent as every organization's default choice of data store.

Tell us about your involvement with the greater Postgres community. 

Just becoming involved.  I have been heavily involved in the Oracle user community for almost 25 years, and I have been getting involved in the Microsoft user community for the past 3 years.

What features should be developed/improved and released in the next major upgrade?

pgPL/SQL

Why should attendees come to your talk at PostgresConf US 2018? What would you like for them to take away from your session?

Creating environments for software development on PostgreSQL must include data masking to prevent confidential data from "bleeding" over from production to non-production environments.

What sessions are you most excited about attending at PostgresConf US 2018?

Mastering PostgreSQL Administration

What is your favorite aspect of PostgresConf US?

Networking with my new technical community

What advice would you have for a Computer Science graduate or entry level developer who are interested in learning and engaging with Postgres?

What is learned when optimizing PostgreSQL is also applicable to other databases

Bonus Question: You can invite any three living people from anywhere in the world to dinner. Who do you invite and why?

Vladimir Putin, Michelle Obama, and Justin Trudeau.  Differing people with different accomplishments on the current world stage, and I would be fascinated to listen to how they react to one another (and to me) once the barriers and inhibitions are dropped.

 

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

 

 

Attention PostgresConf US 2018 registered (and potential) attendees -- our discounted room block at the Westin Jersey City Newport has sold out! We have arranged to add an additional small block, lasting until Monday, March 26th or until it sells out.

HOWEVER, these rooms are selling fast so make your reservation ASAP if interested in staying at the Westin with the special conference rate of $260/night plus applicable taxes for attendees who make their reservations via the dedicated Westin webpage or via telephone (888) 627-7148.

If booking via telephone please mention "PostgresConf US 2018" to receive the group rate. Guest room wifi is included in the room rate.

The Westin Jersey City Newport is the best place to stay and enjoy all conference activities. Attendees will mingle at the Westin bar and hallways throughout the afternoon and long into the evening.

Additional Lodging Options

The DoubleTree by Hilton Hotel Suites Jersey City and the Courtyard Jersey City Newport  are two conveniently located hotels just a short walk from the conference. Rooms may be booked via their respective websites.

PostgresConf US Attendee Poll - Action Needed!

Our PostgresConf US 2018 poll is now open -- your input is valued!

Please take two minutes to provide feedback so we can ensure that the conference is a great experience. Registered attendees should have received an email this week with the poll link. Contact us at organizers@postgresconf.org if you did not receive the poll link.

The purpose of this quick poll is to note any dietary restrictions and gauge interest in the Greenplum and RIS Summits, as well as some of our popular sessions so that we can assign room spaces accordingly

Sponsors

During PostgresConf, you will have plenty of opportunity to meet our great sponsors, including:

  • Diamond: Amazon Web Services, Pivotal
  • Platinum: Compose, OpenSCG, 2ndQuadrant, Microsoft
  • Many more!

For more information, please visit our website https://postgresconf.org/conferences/2018.

Need further assistance? Contact us at organizers@postgresconf.org.

We look forward to seeing you in April in Jersey City!

Debra Cerda     March 21, 2018     postgres

 

As part of the countdown to PostgresConf US 2018, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Hubert Zhang will co-present with Jack Wu at PostgresConf US 2018 on "Customize and Secure the Runtime and Dependencies of Your Procedural Languages using PL/Container." Hubert is a staff software engineer at Pivotal. He received his Master Degree at Peking University, with a major in artificial intelligence. He is most interested in database systems and distributed computing platform.

Tell us about your involvement with the greater Postgres community. (How long have you been involved? How have you contributed? How else would you want to contribute?)

I've been working on Postgres based MPP database Greenplum and HAWQ since 2014. I contributed on PLContainer in Greenplum, data locality, and Ranger module of HAWQ (a SQL-On-Hadoop system).

What features should be developed/improved and released in the next major upgrade?

Vectorize execution for OLAP queries.

Who should attend your talk at PostgresConf US 2018? What would you like for them to take away from your session?

Data scientists and anyone who want to use Python and R in database to do data analysis and machine learning. You'll learn how to use PLContainer as well as how to build a customized docker image to setup your specialized Python or R environment.

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

 

Pavan Deolasse is a PostgreSQL consultant for 2ndQuadrant, one of our Platinum Sponsors for PostgresConf US 2018. Learn more about Pavan in this Community Profile:

Pavan Deolasee is a contributor to the development of PostgreSQL and related technologies. He holds a Masters of Technology in Computer Science from the Indian Institute of Technology, Bombay, and has several publications to his credit.

Pavan was introduced to PostgreSQL in the year 2006 when he started working for a PostgreSQL company. Hacking PostgreSQL was a completely new experience, but by accepting help from the community -- especially Simon Riggs, his mentor -- he began working through the code and was soon working on a very important project (Heap-Only-Tuple aka HOT). It was a very complicated piece of work, yet one of the landmark features in PostgreSQL and to this day remains one of his most important contributions to the project. Pavan has since contributed several patches to PostgreSQL. 

HOT was committed to PostgreSQL in 2008 and Pavan has continued to stay fully engaged with the project. In 2009/2010, alongside other colleagues, Pavan started work on Postgres-XC, a distributed, shared-nothing, clustering solution based on PostgreSQL. He was involved in designing the high-level architecture of the solution, and later wrote many important pieces of the code such as the GTM, the GTM Proxy, the 2PC transaction controller at the coordinator, changes required to guarantee global consistency of the data, and many distributed planner and executor pieces.

When Postgres-XL, a fork of Postgres-XC, was released to the public in 2014, Pavan once again became involved with the project and has been leading the development of Postgres-XL ever since. 

Pavan joined 2ndQuadrant not long after in April 2015, and once again started working with long time colleagues and friends; he and 2ndQuadrant have continued to actively work on the development of Postgres-XL. The focus area of development has been stability and performance of the product while keeping the fork as close to open source PostgreSQL as possible. The most recent release (Postgres-XL 10) supports intra-datanode query parallelism, thus taking distributed query processing to the next level.

In 2013, Pavan and two of his colleagues started the India PostgreSQL User Group. They started conducting small meet-ups, in order to promote the technology in India and bring the local community together. These small gatherings have now expanded with a membership of over 600 members, and into a full scale conference: PGConf India, Asia's largest PostgreSQL conference with more than 250 people in attendance each day in 2018. 

As part of the 2ndQuadrant team of PostgreSQL developers, Pavan continues to work on many interesting new features. He is an active part of the production support team and also has the opportunity to investigate interesting customer problems, often leading to important and critical bug fixes to the open source project.

Pavan had this to say about his involvement with the project:

“I love PostgreSQL and the PostgreSQL community, so you will continue to see me around.”

 

Speaker Spotlight Jignesh Shah

 

As part of the countdown to PostgresConf US 2018, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Jignesh Shah is Product Manager for Amazon RDS with Amazon Web Services. At AWS he works on PostgreSQL engines at AWS including Amazon RDS PostgreSQL and Amazon Aurora with PostgreSQL compatibility. He has worked with PostgreSQL since 2005 and has released application and database lifecycle products using PostgreSQL at appOrbit and VMware.

Jignesh will be co-presenting the full day "Amazon Relational Database Service for PostgreSQL and AWS Database Migration Service Training" on April 17 at 9 am, as well as the "Deep Dive into the RDS PostgreSQL Universe" session on Friday, April 20 at 9:50 am. 

Read what he has to say about Postgres and why to attend his session:

 

Why PostgreSQL?

Features, Open Source, License!

Tell us about your involvement with the greater Postgres community.

Involved since 2004ish. Early part focussed more on performance on high end servers. (Performance bottlenecks, working to resolve them in standard PostgreSQL) Lately more as an advocate.

What new features of PostgreSQL 10 are you most excited about?

Pub/Sub Logical Replication

What features should be developed/improved and released in the next major upgrade?

CALL Procedure (multi-transaction), SQL Packages

Why should attendees come to your talk at PostgresConf US 2018? What would you like for them to take away from your session?

Learn about the features in Amazon RDS for PostgreSQL and how best to leverage them!

What sessions are you most excited about attending at PostgresConf US 2018?

Keynotes!, Tutorials (Aurora, DMS), Customer sessions!

What is your favorite aspect of PostgresConf US?

Meeting the user community of PostgreSQL

What advice would you have for a Computer Science graduate or entry level developer who are interested in learning and engaging with Postgres?

Start with the use cases. Learn how PostgreSQL supports these use cases. Dive deeper on why PostgreSQL solves them in that particular way!

 

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

Debra Cerda     March 14, 2018     postgres postgresql speaker spotlight AWS RDS