Debra Cerda Blog Posts

 

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.”

 

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

Meet Ry Walker, Founder and CEO of CoreDB, which is currently in private beta. CoreDB "provides provides a fully-managed, secure, scalable Postgres cluster with access to an ecosystem of extensions, expanding the capabilities of a database." Ry is a long-time coder, founder investor and champion of open source. He enjoys nature, science, art, tennis, platform tennis, golf, basketball, fishing and indie game development.

Read what he has to say about Postgres and why to attend his keynote session "The Growing Postgres Ecosystem" on Thursday, April 20th:

 

Why Postgres? Tell us about your involvement with the greater Postgres community.

I've been a user since the beginning, recently started CoreDB which will provide a managed Postgres SaaS.

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

Learn about exciting Postgres extensions and what CoreDB is planning to contribute to the ecosystem

What is your favorite aspect of Postgres Conference?

I'm a first timer :)

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

Blog about your journey.

 What's your top suggested readings for 2023?  Books, blogs -- from fiction to non-fiction to technical, anything you enjoy?

The Hobbit :)

What do you believe are the major achievements of open source and Postgres over the last decade?

The rise of open source and open core companies is exciting!

 

Check out the full schedule for Postgres Conference Silicon Valley 2023, and buy your tickets soon!

Debra Cerda     April 12, 2023     speaker spotlight postgres

 

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

Bryn Llewellyn is a Technical Product Manager at Yugabyte, Inc., which offers an open source, cloud native distributed SQL database that looks like PostgreSQL to the developer. Bryn’s speciality is SQL and stored procedures in the context of distributed SQL.

Bryn has worked in the software field for more than forty years. He started working with SQL when he joined Oracle UK in 1990. He relocated to Oracle HQ (Redwood Shores, CA) in 1996 and his last role, before leaving, was as the Product Manager for PL/SQL. He left Oracle in April 2019 to join YugaByte, Inc.

Bryn started off doing image analysis and pattern recognition at Oxford University (programming in FORTRAN) and then worked in Oslo, first at the Norwegian Computing Center and then in a startup. In Norway, Bryn programmed in Simula—recognized as the first object-oriented programming language and as the inspiration for C++.

Bryn will be presenting a mini-tutorial on Friday, April 21st at 9:30am Pacific Time on "How to configure a PostgreSQL cluster for multitenancy." Read what he has to say about Postgres and why to attend his session:

 

Why Postgres? Tell us about your involvement with the greater Postgres community.

I work for Yugabyte, Inc. (Learn more about Bryn's background). YugabyteDB uses the PostgreSQL query processing code “as is” on top of its own open source Spanner-like distributed storage system. I started at Yugabyte four years ago. And that’s when I first started to learn and to use PostgreSQL. My job is to document YugabyteDB’s SQL and PL/pgSQL functionality. This, by construction, has the same syntax and semantics as does vanilla PostgreSQL. I therefore ask lots of questions on the “pgsql-general” mailing list and, very occasionally, discover bugs in vanilla PostgreSQL.

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

Actually it’s a feature that’s new in Version 14: the new syntax for “language sql” functions that lets you define the body without making it a text literal so that it’s parsed at “create” time—allowing proper dependency tracking (and other benefits).

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

I would dearly like to see new functionality for "language plpgsql" subprograms that’s comparable to PL/SQL’s “package” construct (in Oracle Database).

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

I describe a practical solution to a genuine problem. And I make all the code easily available for download from the GitHub repo.

What is your favorite aspect of Postgres Conference?

Meeting real PostgreSQL practitioners and talking with them about their real-world use cases.

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

Get a job where you use the technology on a daily basis.

 What's your top suggested readings for 2023?  Books, blogs -- from fiction to non-fiction to technical, anything you enjoy?

Our Yugabyte blog!

What do you believe are the major achievements of open source and Postgres over the last decade?

How YugabyteDB has made the familiar PostgreSQL functionality available as an open source, cloud native, massively scalable and fault tolerant, distributed SQL database system. (Of course, I would say this!) 

Anything else to add?

I’m excited to be attending (again), and speaking (again) at the Postgres Conference Silicon Valley.

 

Check out the full schedule for Postgres Conference Silicon Valley 2023, and buy your tickets soon!

Debra Cerda     April 11, 2023     speaker spotlight postgres
Modern Webinar Business Linked In Post (Billboard Fina

Are you interested in learning about the latest developments and best practices in PostgreSQL? 

Then you won’t want to miss next week’s Postgres Conference Silicon Valley 2023! This annual conference brings together experts and enthusiasts from around the world to share their knowledge and experiences with the PostgreSQL community.

This year's conference will be held in San Jose April 20 and 21, 2023, at the San Jose Hilton, and promises to be another exciting and informative event. Attendees can expect a wide range of presentations, mini-tutorials, and networking opportunities, covering Postgres and open source related topics such as high availability, migration, security, machine learning, AI and much more.

Whether you're a seasoned PostgreSQL developer, a database administrator, or just curious about this powerful open-source database system, Postgres Conference Silicon Valley is the perfect place to learn and connect with like-minded individuals.

So why should you attend? For starters, you'll get to hear from some of the brightest minds in the PostgreSQL community. You'll learn about the latest trends and technologies, and gain valuable insights from real-world use cases and case studies. Check out our full program.

In addition, you'll have the opportunity to network with other PostgreSQL professionals and enthusiasts, and build relationships that can benefit you and your organization long after the conference is over. 

Be sure to stop by the exhibit area and chat with our incredible sponsors and partners, including our Conference sponsors CoreDB and Amazon Web Services (AWS) as well as our Cloud sponsor Google Cloud and Distributed SQL Summit (DSS) sponsor YugabyteDB. Our Conference Partners for this year include Airbyte, Command Prompt, Inc., DBeaver, Fujitsu, Neon, Nutanix, Percona, pgEdge and Community Partner OnGres.

Postgres Conference Silicon Valley is also a great chance to explore the local area, with plenty of opportunities for sightseeing, dining, and entertainment. A Welcome Reception will be hosted by YugabyteDB on Thursday evening for all registered attendees. 

So if you're looking to expand your knowledge of PostgreSQL, connect with other experts and enthusiasts, and have some fun along the way, be sure to register for Postgres Conference Silicon Valley today. We can't wait to see you there!

 

Debra Cerda     April 10, 2023

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

Meet Tatiana Krupenya, CEO of DBeaver. DBeaver provides a GUI interface that "connects to all data sources and stores, enables special extensions for big data databases, and includes supplemental features like a data viewer, an editor, mock data generator, metadata browsing and visual query builders, enabling users to dynamically access all of their databases while working within one environment."

Tatiana will present "Let robots help with queries" at this year's conference. Read more about Tatiana below:

 

Why Postgres? Tell us about your involvement with the greater Postgres community. 

DBeaver is one of the most popular UI tools for Postgres administration and data management. We support not only PostgreSQL itself but all popular forks and Postgres-based data sources, like Greenplum, Yugabyte, Redshift and others.

Why should attendees come to your talk at Postgres Conference Silicon Valley 2023? What would you like for them to take away from your session?

We have gotten used to thinking that working with databases is for database administrators and developers. However, thanks to modern technologies, people from other professional areas can also do this. It's data engineers, data architects, financial analysts, machine learning specialists, and others. The only thing that we need is to provide them with a safe and convenient infrastructure. In my talk, I would like to show how OpenAI can help with that.

What is your favorite aspect of Postgres Conference?

The best thing is the atmosphere. You can meet interesting people, learn about cutting-edge technologies, find new partners, and all of these in a friendly and positive environment.

Check out the full schedule for Postgres Conference Silicon Valley 2023. Walk-up registration is still available. Learn more here!

Debra Cerda     April 20, 2023     speaker spotlight

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

Meet Dave Stokes, Technology Evangelist for Percona. Dave Stokes is the author of MySQL & JSON - A Practical Programming Guide. He resides in Texas with the mandated pickup truck, hound dog, and guitars.

Read what Dave has to say about Postgres and why to attend his sessions which include "MERGE() - A Quick Introduction" and "PostgreSQL High Availability: The Considerations and the Candidates."

 

Why Postgres? 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 have been mainly involved in the MySQL Community for a long time but am now exploring PostgreSQL. I have started a series on PostgreSQL for MySQL DBAs that is very popular

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

Merge()!

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

JSON_TABLE()!! Please, please, pretty please!!

Why should attendees come to your talk at Postgres Conference Silicon Valley 2023? What would you like for them to take away from your session?

From the Merge() talk, I hope they will go away understanding how transaction log processing works. For the HA talk, I do not expect them to walk away as they will be so filled with brain energy that they sort of levitate away!

What is your favorite aspect of Postgres Conference?

The people.

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

Open source !- free. It provides a flexibility to innovate.

What's your top suggested readings for 2023?

Anything by Tim Dorsey.

What do you believe are the major achievements of open source and Postgres over the last decade?

Open-source software has proven that good code comes from more than just semi-benevolent corporations. And PostgreSQL has proven the power of the mailing list!

Check out the full schedule for Postgres Conference Silicon Valley 2023, and buy your tickets soon!

Debra Cerda     April 17, 2023

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!

 

 

Speaker Spotlight Baron Schwartz

 

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.

Baron Schwartz is the founder and CEO of VividCortex, the best way to see what your production database servers are doing. Baron has written a lot of open source software, and several books. He’s focused his career on learning and teaching about performance and observability of systems generally (including the view that teams are systems and culture influences their performance), and databases specifically.

Baron will be presenting a breakout session "How To Index Your Database" on Friday, April 20th at 12:50 pm. 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 community has always been what’s drawn me to Postgres. From the very first I could immediately sense the deep commitment people had to the database and other people involved with the database. Each database community is special in its own way and has its own culture, and after being involved in many of them you sense it in a way you can’t explain. Postgres’s is loyal to freedom, independence, quality, and principles. All are dear to me as well.

Tell us about your involvement with the greater Postgres community.

I’ve participated since 2008 in various ways. I’ve blogged, written open source, written books, reviewed and tech-edited other people’s books, spoken, and attended. I hope to continue doing so!

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

Partitioning! Improved streaming replication! Parallel query execution! There are so many improvements. The pace of development is really impressive.

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

The database of the microservices-oriented future is only quasi-stateful. By this I mean that it acts almost like a read-through cache in front of “cold storage” like S3. Support for creating an empty database cluster, and having it fetch its data from cold storage on first query, would be game-changing for cloud-native apps. I realize that’s a lot of buzzwords, but it’s going to happen soon!

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

Indexing is at once the most important, simplest, and most complicated topic in designing a database; I hope to make it simpler and leave people with three big things they will never struggle to remember.

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

I'm really interested in hearing how others are using Postgres, both for creative purposes that showcase its flexibility and extensibility, as well as "use as designed." In my opinion, the best conference talks aren't "you should do this"; types of talks: they are "I did this and here's what happened"; I love stories!

What is your favorite aspect of PostgresConf US?

That’s an easy one to answer: seeing all my old friends again!

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

Computer Science seems to feel that algorithms, data structures, and so on are fundamental. Data persistence, especially relational, is equally important. Don’t neglect.

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

I invite the three hungriest people in the world and eat mindfully with them, so I learn to appreciate what I have.

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